Importing Error

  • Thread starter Thread starter Curtis Stevens
  • Start date Start date
C

Curtis Stevens

I was using Access 2002 and when I upgraded to 2007, it was running much
slower. So I decided to try this. Create a new database in 2007 and import
everything from my database file.

However, when I did this, all of my events that have an event procedure give
me an error.

See for screen shot of error: http://www.gotmerchant.com/error.jpg

They worked just fine before?

Curtis
 
Hi Curtis,

When you do an import, you have to make sure your references are all in
place. In the Visual Basic Editor, go to the Tools menu and choose
References. Do that in the old database to see what is selected and then in
the new database to select the same or comparable items. Choose the newest
version if there are multiple versions. Then do a compile of the code to see
if all of them are in place or if there are other errors. That is on the
Debug menu. Some references may not be needed so you might try removing them
one at a time and compiling. If it still compiles without errors after you
have removed one, then it is not needed. Now try your forms and whatnot to
see if they work.

Clifford Bass
 
Back
Top