Search results

Thanks, I have automated the pass-thru queries and will test on another clients application. The next step is to automate the pushing (or pulling) of Access 2007 table updates to SQL Server 2005 for clients to pull (using the pass-thru queries) into their Access 2007 apps.

I am a beginner and stumped attempting what sounds like a simple task: Repopulating Access 2007 reference tables (static) from SQL Server 2007. I am using VBA and ADO connection to create a recordset of the SQL Server table(s) with no problem: I can't find out how to use this recordset to...