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.
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…