Updating ms access table
In an application that uses linked SQL Server tables, two different database engines are at work: the Office Access/Jet database engine that runs on the Office Access client and the SQL Server database engine.
The interaction of these two engines can sometimes yield results that are inferior to those obtained by using only the Jet database engine with native Office Access tables.
I "THINK" what I need is VBA code that will copy the open workbook, reach out to access and paste append the data into a staging table. As always, be very careful when editing the Windows registry.For more information on backing up and editing the registry, see How to Modify the Windows Registry.There are two tools that you can use to see how Office Access is communicating with SQL Server.To listen in on the conversation from the server side, you can open the SQL Server Profiler and create a new trace.