Rx_
Nothing In Moderation
- Local time
- Yesterday, 21:14
- Joined
- Oct 22, 2009
- Messages
- 2,803
Access 2007 - linking Access 2007 Be on network or C:\ drive folder
Linked Table Manager, Always Prompt for New Location, Select All
Choose a Be (back end tables) 2007 Access db
Problem: each and every table asks for the user to re-select the Access 2007 Be path again, and again, and again.
However: Instead of Select All, check 3 to 8 tables at a time and it will update just the 3 to 8 all at once (as it normally should).
Earlier this week, it behaved properly dozens of times and updated all tables (selct All) with a single click.
Not using ODBC, just directly linking Access 2007 to Access 2007.
Started on the network. Then copied both the front end and backend to the C:\ drive root folder just to make sure it is not network latency or something like that. Same exact issue.
Did compact and repair the Front End database.
Did compact and repair the Back End database.
I might end up writing some code to re-link this.
But, wondered if anyone has any ideas why this happens, how to prevent it, or how to best recover?
Linked Table Manager, Always Prompt for New Location, Select All
Choose a Be (back end tables) 2007 Access db
Problem: each and every table asks for the user to re-select the Access 2007 Be path again, and again, and again.
However: Instead of Select All, check 3 to 8 tables at a time and it will update just the 3 to 8 all at once (as it normally should).
Earlier this week, it behaved properly dozens of times and updated all tables (selct All) with a single click.
Not using ODBC, just directly linking Access 2007 to Access 2007.
Started on the network. Then copied both the front end and backend to the C:\ drive root folder just to make sure it is not network latency or something like that. Same exact issue.
Did compact and repair the Front End database.
Did compact and repair the Back End database.
I might end up writing some code to re-link this.
But, wondered if anyone has any ideas why this happens, how to prevent it, or how to best recover?