I have 2 Access databases; each has a linked table set up to the exact same SQL table. Both are trusted ODBC connections using the same DNS. One allows the table to be updated the other does not.
The only differences in the connections string are as follows:
>> One the works has: “APP=Microsoft Data Access Components”
>> One the doesn’t has: “APP=2007 Microsoft Office system”
I believe there is a table size limitation with “APP=2007 Microsoft Office system” because when the table was smaller the update worked fine.
Question: How can I update the connection sting on the one that fails to use “APP=Microsoft Data Access Components”? I tried the refresh link table but that had no effect on APP
I can’t delete and re-add the linked table because the user has a ton of queries written over it.