Convert MS Access'97 to MS Access 2000

[john]

Hi,
I have a file of MS Access'97 and want to open it under MS Access 2000...the
problem is the visual basic did not work properly.
Would like somebody help.? How to convert Access 97 file to Access 2000.


txs
benny

 

[Alex White MCDBA MCSE]

Do you need to ever open it is Access 97 again?

Is your database Spilt:? e.g Front-end /Back-end

Is your 'file' an MDB or MDE?

 

[john]

I don't need to open it in Access'97 again.
It is not Spilt and in MDB file.
Thanks in advance for your help.

txs

 

[Alex White MCDBA MCSE]

make BACKUPS,

When you try to open it in Access 2000 you should be being asked to convert
it?,

after converting, you will need to go into code view and goto
tools/references you are looking for the word 'missing' in any of the ticked
references sort them out if you have any.

then click on the debug/compile menu option (if it is greyed out go into a
code module press enter a couple of times within a code block, this make the
compile think it needs re-compiling, then try debug/compile)

depending on what you want, in some cases that is all you need to do!

 

[Douglas J. Steele]

Does it compile in Access 97?