Access 2000

A

Antz

we want to upgrade our Access 97 to 2000
will DB is 97 still be accessed? via 2000
and worked on?

thanks
 
R

Rick Brandt

Antz said:
we want to upgrade our Access 97 to 2000
will DB is 97 still be accessed? via 2000
and worked on?
Click to expand...

The general rule is if an Access 97 file is "healthy" that it will convert
to a newer version and work without incident. By definition of healthy
would be no compile errors and no corruption. So while in Access 97 do the
following...

Compact

Open a code module and run a "Save and Compile All"
(fix any problems found)

Attempt to make an MDE file from it. If you can successfully create an MDE
from the Access 97 MDB then chances are it will convert to the newer version
just fine.
 
A

Antz

thanks!!!

Rick Brandt said:
The general rule is if an Access 97 file is "healthy" that it will convert
to a newer version and work without incident. By definition of healthy
would be no compile errors and no corruption. So while in Access 97 do the
following...

Compact

Open a code module and run a "Save and Compile All"
(fix any problems found)

Attempt to make an MDE file from it. If you can successfully create an MDE
from the Access 97 MDB then chances are it will convert to the newer version
just fine.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I install Access 2003 under MS Office 2007 1
Weird problems installing Access 97 on WIndows 2000 Profressional 3
Issues after 2K7 Conversion 3
Can an Access 2003 file be accessed via Access 2000? 1
Application slow after conversion 1
Performance difference between Access 97 and Access 2k 5
Access 97 Runtime with Access 2000 installed 7
Upgrading Access 4

Top