Converting Database from Access 97 to Access 2000

[lmcgowan]

I have jst converted my database from access 97 to access 2000. And I got the following message.


"There were compiliation errors during the conversion or enabling of this database.

The database has not been saved in a compiled state. The performance of this database will be impaired bacause Microsoft Access will need to recompile the database for each session. "

Could someone please help me and tell me how I get get the database into a compiled state in Access 2000.

Thnaks

 

[DBL]

From the database window, do Alt F11 and the modules will open up. On the toolbar go to Debug and select Compile. You should probably check that you don't have any missing references first. Still in the module window go to Tools>Refrences. If there is anything marks as "Missing", tick the box and then compile the code.

 

[lmcgowan]

DL thanks for replying to me. I have done as you said. But is there a way that I can check if my database is in a compiled state now.

 

[DBL]

If you follow the procedure again to compile the code and the option to compile is greyed out then the database is in a compiled state.

Glad you got it sorted.

D