Need to move database

[Bonnie]

We use Access for a membership database. My organization
has been using a version of Access that is at least 5 yrs
old (Access 2.0??) & now wants this put on another
computer (not networked), Access 2002 onboard, where
internet access is available. I have attempted to copy to
file several times without success. Any tips,
suggestions, or hints? I really do not want to have to
enter over 20,000 records manually. What problems should
I anticipate jumping so many versions?

 

[Jeff Boyce]

Bonnie

I'd suggest that you re-compile your Access 2.0 db before attempting to
import/convert. This will minimize the issues you face.

Access 2.0 ran under, I seem to recall, 16 bit Windows. With more recent
versions, Windows is 32-bit. If your old (2.0) db had any API calls in code
modules, they may not function properly until converted to their 32-bit
counterparts.

The VERY first thing to do is back up your application and data!

It is quite do-able -- you are not the first to face this. You should be
able to make the conversion without having to re-enter the data.