How can I change the file path/location of my tables

I have copied an application to a different location on my HDD in and
attempt to modify and and test changes without affecting my original
application. Unfortunately the copied application still looks for the
tables, queries, etc. in their original location. Is the path/location
of these tables, etc. accessible ... even if I have to do it in code?

Easy as pie!

Open up your db (the front-end).
Tools-Database Utilities-Linked Table Manager (a dialog will open)
Click the 'Select All' button and the 'Always prompt for new location'
check box
Click 'OK'
Then simply choose where to find the table (your new location).
--
Hope this helps,

Daniel Pineault
If this post was helpful, please rate it by using the vote buttons.



"ZZX" "Bob.No SpammmmCallen" wrote:

I have copied an application to a different location on my HDD in and
attempt to modify and and test changes without affecting my original
application. Unfortunately the copied application still looks for the
tables, queries, etc. in their original location. Is the path/location
of these tables, etc. accessible ... even if I have to do it in code?

That did it! ... Thanks!

Daniel Pineault wrote:
Easy as pie!

Open up your db (the front-end).
Tools-Database Utilities-Linked Table Manager (a dialog will open)
Click the 'Select All' button and the 'Always prompt for new location'
check box
Click 'OK'
Then simply choose where to find the table (your new location).