I have created an Access Database that some of my coworkers would like to be able to take home to use during weekends. The main database is entitled "Finance Queries", and contains all the forms, queries, macros and code and is what the user interacts with. I have another database entitled "Finance Views" which stores all the data; "Finance Queries" has links to all the tables in "Finance Views" and uses it to run. For obvious reasons, my coworkers cannot simply take Finance Queries home and use it; it links to Finance Views, which is stored at a particular network location. Since that location doesn't exist on people's home computers, my database won't run.
I would like to remedy this problem by writing code and utilizing a common dialogue box that allows the user to browse to a new location of Finance Views (assuming they copied the file to disk and brought it home) and then relinks all tables based on this. I know about the Database Utilities -> Linked Table Manger, but I would like to automate this process for my users. There are about 20-30 tables in Finance Views, and it would be nice if my users could browse to the proper location once rather than 20-30 times.
So...I really have no idea how to go about writing code that would relink the tables. I've gotten a common dialogue box to work, so I can do that...I just need to know how to make Access relink the tables given the new location. Any help you can provide would be super-appreciated.
Thanks!
I would like to remedy this problem by writing code and utilizing a common dialogue box that allows the user to browse to a new location of Finance Views (assuming they copied the file to disk and brought it home) and then relinks all tables based on this. I know about the Database Utilities -> Linked Table Manger, but I would like to automate this process for my users. There are about 20-30 tables in Finance Views, and it would be nice if my users could browse to the proper location once rather than 20-30 times.
So...I really have no idea how to go about writing code that would relink the tables. I've gotten a common dialogue box to work, so I can do that...I just need to know how to make Access relink the tables given the new location. Any help you can provide would be super-appreciated.
Thanks!
