Hello to all ,
I have an access application that is linked to 3 different databases.
How can I change the path of this 3 databases and relink the application to the new 3 database paths
with vba function.
Thank you from advance.
Benjamin
Hello to all ,
I have an access application that is linked to 3 different databases.
How can I change the path of this 3 databases and relink the application to the new 3 database paths
with vba function.
Thank you from advance.
Benjamin
Welcome to the forum.
The simplest method is to use the linked table manager.
However if you need to swop paths on a regular basis then a vba procedure is worthwhile.
I use DSN less connections and gave a detailed account with code of my approach in post #18 of this thread https://www.accessforums.net/showthr...ght=connection.
It works for any backend databases: Access or SQL Server etc
Others will have different approaches.