Migrating Access files from PC to Windows 2003 Server

  • Thread starter Thread starter SOE
  • Start date Start date
S

SOE

I have a Dell Dimension desktop using Access 2002. Want to
migrate my data files over to my 2003 Serever Enterprise
edition. Have Access 2003 on Server.
Questions:
What is the best way for me to migrate my
application from the PC to the new MS-2003
Server?

Can I just move the "data files" for my
MS-Access application from the PC to the
new MS-2003 Server?

Do I have to run a conversion script?

Do you have a list of Frequently Asked
Questions (FAQ) that I can refer to regarding
a migration such as this?

Can you send me a document (or refer me
to a document) that clearly explains how
to do what I need to do. I want to make
sure that I move ALL REQUIRED FILES and
DO NOT LEAVE ANY SPECIAL MS-ACCESS DATA
FILES BEHIND ON THE OLD PC.
 
Each database is one file only, typically with the
extension .mdb (just as word documents typically
have the extension .doc). There are no special
MS-Access data files. Just move your data files,
exactly like you would move your Doc files.

(david)
 
Hi SOE,

If your "application" consists of a single .mdb or .mde file, just copy
it to a folder on the new machine. No conversion will be needed for the
change from Access 2002 to 2003, though you may have to update settings
or data in the database itself to reflrect the change in computers (e.g.
locations of external files may have changed).

If it's split into back end and front end .mdb or .mde files, copy them
both to suitable folders and use the linked table manager to re-link the
tables in the front end to the new back end location.

Outside those basic cases, it all depends on what the application is and
does. If it originally had to be installed with a custom program or
script (e.g. to install a third-party control) you'll need to install it
on the new machine in the same way in order to ensure that other
necessary files and settings are re-created on the new machine. If it
connects to external data sources you'll need to ensure that these are
available on the new machine.

When I switch computers I always make a copy of the whole of the old
C:\Documents and Settings\ and C:\Program Files\, together with any
other folders where I've been keeping documents or data - either onto
the new machines' HD or onto an external drive. That way I can be
reasonably sure of not losing anything.
 
Back
Top