Need to move database from "old" to "new" computer

[Bonnie F.]

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?

 

[Ernie]

1) either get a network connection between these two
computers
or
2) install the hard drive from the old computer in the new
one (temporarily) so that you can copy directly.
or
3) email the db as a zipped attachement to the new
computer.

If you are unable to do this, then
3) export all of your tables to text files (csv preferred)
and copy the text files to the new location, then import
them into a new access database.
4) once you have export/import of the tables, then copy
the queries, forms, reports, etc to the new database,
making any changes necessary for the new version.

 

[Pat Hartman]

Do you mean that you've attempted to convert the file?
What happens? Version 2.0 has been around since around
1993 so that would make it 11 years old. I guess it's
time to upgrade. Before you attempt to convert the db,
compile it in 2.0 and fix any compile errors. Also, if
you have any DAO code in the db, it is best to qualify it
prior to conversion. So, find all the Dim database,
recordset, querydef, tabledef, etc. and qualyfy them - Dim
DAO.database, DAO.Recordset, etc. Remove any dead code
that used to be attached to form events, etc. I have
never tried to convert 2.0 to AXP so I'm not even sure you
can do it. You may need to convert to A97 along the way.

 

[Bonnie F.]

Your explanation sounds wonderful but I have NO idea what
it means. I've worked with Access for less than 2 months
without any reference manual or previous training. I
enter names & make mailing labels... that's it. I
thought this would be like Excel or Word where you "copy"
& "paste." Boy, what a job!