The situation: The client is using data, which is being edited. I wish to work around in the VBasic programming and Access form design, and to be able to "connect" to the data when a new update of the program is ready.javascript:smilie(':o')
javascript:smilie(':o')

The idea: I will leave all data in a separate database (DATA.mdb), and build all programming, forms, queries, in a second database WORKING.mdb, whose tables are only "links" to the tables of the first mdb.

The problem: I need to relocate the databases, changing from one directory to another, but the linked tables have a "fixed" pathname.javascript:smilie(':rolleyes:')
javascript:smilie(':rolleyes:')

The question: Can somebody tell me if it is possible to change the location of the source data directories?
javascript:smilie(':confused:')
javascript:smilie(':confused:')
:o :o :o

Use the linked tables manager. Tools/DatabaseUtilities/LinkedTablesManager
Check the "always Prompt" box at the lower left, select all tables and press ok.