By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,335 Members | 2,281 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,335 IT Pros & Developers. It's quick & easy.

File Paths

P: 1
I have changed the file paths in linked tables and now the queries are all empty. Should I be doing something else?
Feb 7 '12 #1
Share this Question
Share on Google+
2 Replies

Seth Schrock
Expert 2.5K+
P: 2,941
I have had problems with Access not following the new updated location as well. I'm assuming that you have your tables in a backend database with all your form, queries, reports, etc. in the front end. You need to delete the linked tables from the front end database (this just deletes the link, not the data or tables in the backend). Then, re-import the tables as linked tables from the new database location. This is basically the manual way of updating the linked file location. I'm not sure why the automated way doesn't work, but I have never been able to get it to work in Access 2010 (the only version that I have tried to do this in).
Feb 7 '12 #2

Expert Mod 15k+
P: 31,494
Your question is barely adequate not to be deleted (possibly I should have), but if you're doing this with code (The question doesn't even include that level of detail) then you will need to call the .RefreshLink method of the TableDef object after the .Connect property has been changed.

More can be found at Relinking ODBC Tables using VBA.
Feb 8 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.