Thanks for the suggestion. I gave it a try and changed the source server in the connection string but I still get the same connection error.

> Otherwise - I would be very leery of any object remaining in Access with > 1M rows in it. That is definitively hogging up > your memory. ...

Hi Matt,

Thanks for the tips. Here is how I set it up: I used the upsizing wizard to transfer my tables and queries to SQL Server Express. ...

I wasn't able to restore a database in SQL Server 2000 that was orignally created and backed-up in SQL Server Express. A google search indicated that this is because...

Thanks Chris. I'll review my recordset loops and detail and attempt to change them to UPDATE sql. In your experience, can most/all recordset looping operations be changed to...

Thanks Elisabeth. I wasn't sure if this method would capture my stored procedures and functions along with all of the table data.

Hi Wayne,

You are in the same situation as I am. I have upsized my Access DB to SQL Server Express and now my existing DAO code has to be...

Thanks again Jo!

To get it working I added:

Dim aob As AccessObject

For Each aob In CurrentData.AllQueries

If aob.Name = "Query of Interest " Then

...

Thanks Jo. I set up Access linked tables to SQL Server via ODBC. I find the VBA code runs much slower now. The code loops through large...