November 15, 2007 at 8:11 am
Hi,
We have a number of SQL tables linked to a MS Access database. We added some fields to one of the SQL tables. However, when we go back to the Access database the new fields are not showing when we open the linked table in access.
Can someone explain to us why this is happening and how we can correct it? Is there something in Access that is "caching", for lack of a better term, the old SQL table definitions? If so, is there a way we can see what fields are being cached at any given time other than opening the linked table?
Thank you,
Ken
November 19, 2007 at 2:52 am
Access saves the tabledefinition when it is first linked.
Any change in the defintion may result in #deleted entries or not showing additional columns.
Some access-programs have vba-code that drop the old linked table info and relink it again at startup.
(using the autoexec macro)
Starting from Access 2000 there is also a manager to update all linked info.
November 19, 2007 at 7:11 am
Thank you Jo.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply