Upgrading from 2000 to 2010

[spectraflame]

Is there a good reference to explain some of the differences in the 2010 version of MS Access? I have a database in 2000 that has ODBC calls to download multiple tables, execute a query, and output the data to a new table but each time I run it in 2010, Access crashes. I have gone through the save and publish steps but it still does not work.

 

[SydneyGeek]

Does it crash, or do you get an error?

If so, what is the message, and where in the code does it happen?

Denis

 

[spectraflame]

The macro deletes the old version of the downloaded tables and then uses the ODBC connection to download the new version of those tables. I used the Single Step feature and it worked fine with deleting the old versions of the tables but when it got to the point of using the ODBC connection I get the "MS Access has encountered a problem and needs to close" error. I am given the repair option to reopen the report. I have tested the ODBC connection from Excel and it works fine. My next approach will be to use Access to download a single table to see if it functions properly.

 

[SydneyGeek]

What is the ODBC source? Access, or another database like SQL Server? You may find that the ODBC connection needs to be redefined.
Also, is it a macro (point and click) or VBA?

Denis

 

[spectraflame]

After a long conversation with the software provider of the ODBC driver, Transoft, I discovered that the version that I was trying to use was not capable of working with Office 2010. I have since upgraded to a newer version to Transoft and will continue to test but so far it seems to be working OK.

Thanks for all of the suggestions.