Luigi
Last Activity: Sep 24 '07, 09:41 PM
Joined: May 29 '07
Location:
-
I thing you must have an internal table with the Current situation and than another table CONNECT to an excel file (make a working copy of the incoming file with a fixed name). So you can make a COMMAND QUERY that finds the different and up-date the Current table.... -
Thank you very much Lysander. Starting from your example I write the following code.
My external tables are into different directories (the paths are stored in public constants).
I check each table and if there is an error I simply tray to move the connect path to the first possible directory, then I check again and, in case of error, I move the connection to the second and last possible path. At the end I check another time...Leave a comment:
-
I see many answers to a number of other more recent messages, is my problem hard or do I not explained well it?...Leave a comment:
-
move db without lose the connection with external tables
I use Access 2003 on Windows XP OS.
I made an Access application with many linked table (essentialy txt file but also table of other mdb files); how can I move my principal mdb file and its relavant external file in a different directory without have to specify all the new paths through connect tables management tool?
No activity results to display
Leave a comment: