If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linked Tables Update Problem
I use several databases linked back to a main database's tables. I take
copies home to work on and need to take them back to work and update the links. I'm having a problem with one database in particular that will not allow me to select all linked tables, browse out and find the main database to update the links. I browse out to the sub-folder storing the main database and select the database, but it just keeps flipping back to the main folder. It will allow me to select a few tables at a time (sometimes only one) and update. But, now all or even most of them at once. This can be very time consuming. Any idea what may be wrong? Thank you |
#2
|
|||
|
|||
Linked Tables Update Problem
I browse out to the sub-folder storing the main
database and select the database, but it just keeps flipping back to the main folder. It will default to the Default Database Folder setting when first opened, but it "remembers" the directory where a file was selected during the current session and opens that directory first on subsequent imports, exports or linking of tables. I don't know why yours isn't behaving properly. Keep backups and do compact/repairs on a regular basis. You may want to create a brand new database file and import all the objects into this new file. However, there's a work-around. Create a button on a form that runs VBA code that prompts you for the directory and then creates the links for you. For the necessary code, please see the tip, "Relink Access tables from code," on the following Web page: http://www.mvps.org/access/tables/tbl0009.htm Please see the tip, "Call the standard Windows File Open/Save dialog box," on the following Web page: http://www.mvps.org/access/api/api0001.htm HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips. (Please remove ZERO_SPAM from my reply E-mail address so that a message will be forwarded to me.) - - - If my answer has helped you, please sign in and answer yes to the question "Did this post answer your question?" at the bottom of the message, which adds your question and the answers to the database of answers. Remember that questions answered the quickest are often from those who have a history of rewarding the contributors who have taken the time to answer questions correctly. "neenmarie" wrote: I use several databases linked back to a main database's tables. I take copies home to work on and need to take them back to work and update the links. I'm having a problem with one database in particular that will not allow me to select all linked tables, browse out and find the main database to update the links. I browse out to the sub-folder storing the main database and select the database, but it just keeps flipping back to the main folder. It will allow me to select a few tables at a time (sometimes only one) and update. But, now all or even most of them at once. This can be very time consuming. Any idea what may be wrong? Thank you |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to Create Linked Tables At Run-Time | Todd Shillam | General Discussion | 3 | August 20th, 2005 05:55 AM |
query problem with linked SQL tables when importing to new mdb file | Keith G Hicks | Running & Setting Up Queries | 2 | March 22nd, 2005 09:44 PM |
Access application with SQL backend linked table problem | Steve | General Discussion | 0 | February 15th, 2005 09:03 PM |
Linked tables | Loi | New Users | 1 | January 26th, 2005 08:57 PM |
Office XP Update Problem | Bill | General Discussions | 0 | December 1st, 2004 06:11 PM |