Running MS Access 2013, 64 bit on Windows 7. Linking to MS SQL 2012.
I'm getting various errors such as "Inserting on a linked table failed" and "ODBC timed out" when running a series of Append Queries in MS Access to add records into a linked SQL table.
I am running 3 queries over and over building up a table until it is complete. When I run these queries manually, they work fine. When I run them using VBA in a series manner, I get these timeout issues.
Note that before these 3 queries, I run 3 other "base" queries that work fine using this method.
I run every query using the following Sub:
Public Sub ExecuteQuery(QueryName as String)
Dim dbs as DAO.Database
Set dbs = CurrentDB
Set dbs = Nothing