Access2007 VBA code in Access2010 (1 Viewer)

[Mist]

I have developed an application with MS-Access 2007 and it works perfectly. When I try to run it under MS-Access 2010 I get 'compile errors' and 'missing library' errors.

The attachments should illustrate my problem. I will sincerely appreciate any input from someonewith experience here. Many thanks

 

[mdlueck]

Suggestions to perform on a BACKUP copy of your database file

1) Check VBA references between A2007 and A2010. Ctrl-G to get to the VBA screen, Tools \ References. Make sure that all of the references checked in A2007 are checked in A2010.

2) Try this to clean up the database file next (after checking step 1):

NT Command Script and Documented Steps to Decompile / Compact / Compile an Access DB
http://www.access-programmers.co.uk...to_Decompile_/_Compact_/_Compile_an_Access_DB