Upgrading an Access 1 database

[Trevor Lawrence]

I've inherited an Access 1 application running on an old box. I need to try
and upgrade it to Access 2003. Access 2003 won't touch a databse that old.
Does anyone know if there is any alternative to trying to ferret out a
succession of old versions of Access and upgrading bit by bit. Or do I have
the choice of re-writing or stayiing as it is? Rewrite would present a
problem sucking the data out of the old DB.

--
=========================
Trevor Lawrence

TrevorL@@webone.com.au
=========================

 

[david epsom dot com dot au]

To convert the application you need a copy of A2.0,A95,A97.

To just get the data, you can try linking to the database.

If that doesn't work, use

set obj = createobject("dao.dbengine.35)
obj.compactdatabase "old", "new"

to convert to a more recent version first.
(Air code: you will have to modify that code to get it to work)

(david)

 

[Yuhong Bao]

I think what do you need is to upgrade it to Access 2, 95 or 97 first, and
then update your Access Basic code to no longer reference the methods,
properties, and syntax that was made obsolete in Access 2.0. Then you can
upgrade it to 2000 or later. If you decide to upgrade it to Access 2 and
then upgrade it to 2003, you will need this converter:

http://www.microsoft.com/downloads/...F8-F3AB-41E9-902A-2255A66E1C4A&displaylang=en

Hope this helps