converting/migration of MSAccess 2000 database to MSAccess 2003

[Janette]

Hi,

Does anyone know how to convert or migrate a MSAccess 2000 database to
MSAccess 2003. Currently I am having problems where if I open a 2000 db in
2003 it gives a conversion error message.

Regards
Janette

 

[Allen Browne]

Access 2003 can use an Access 2000 file directly, i.e. without converting.

If you receive a conversion dialog when you try to open it, perhaps it is an
Access 97 file?

If not, the file is partially corrupt. Try creating a new (blank) database
in Access 2003, and then importing everything:
File | Get External | Import.

If that does not work but you can open and modify the file in Access 2000,
post back for further instructions on how to fix the problem using the old
version.