I just have a quick question about linking the front end of my database to the backend. On the front end of the database, you click on the option to 'Get External Data' and you specify the file location to attach your back end source to the front end. My question is how to referentially link the front end to the backend. For instance, if the file is in the same folder and without going through the entire location C:\Users\..., how can I just attach it to the source in the same folder?
I've tried ./Source.accdb, and it seems to work. But it keeps on referring back to the long location - C:\Users\... when I scroll over the table.
Ultimately what I'm trying to do is to work on the Development copy locally and when I fix bugs I would just like to copy the front end to the server. This would link automatically to the backend since its in the same folder, thus I wouldn't need to re-link it again.
Let me know!
Thanks in advance