Migration of Access 2.0 to XP

T

troy

Where can i find or what is the step to Migrate an Access 2.0 database to XP? I would like to find information on how to do this and what type of problems that may arise duing the conversion process. any help is greatly appreciated. Also is there 3rd party tools to help with this process/
 
A

Arvin Meyer

troy said:
Where can i find or what is the step to Migrate an Access 2.0 database to
XP? I would like to find information on how to do this and what type of
problems that may arise duing the conversion process. any help is greatly
appreciated. Also is there 3rd party tools to help with this process/

There is no smooth migration path from Access 2.0 to XP. There is, a
relatively smooth path to Access 97, then from 97 to 2002 (XP) Your biggest
problems will come from 16 bit APIs which now must become 32 bit, and Access
Basic code which now needs to be VBA. You may not have any APIs and
rewriting the code is really straightforward, although you may be able to
get away with using the 2.5/3.5 extensibility layer in Access 97, then
setting a reference to it in XP.

The long and short of it is: It could be quick and easy, taking less than a
day. Or it could be a bear. All you can do is start on it and perhaps
sacrifice a chicken or 2 <g>.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
B

Brendan Reynolds

I don't think you'll find much documentation about converting Access 2 to
Access 2002, as Microsoft had stopped supporting Access 2 long before Access
2002 was released. But check the archives for the various Access newsgroups
at www.google.com. There were lots of discussions about converting Access 2
to Access 97 in the late nineties.

To the best of my knowledge, you can not use the DAO 2.x/3.x Compatibility
Library with versions of Access later than Access 97, as later versions use
DAO 3.6, and there never was a DAO 2.x/3.6 Compatibility Library. Old DAO
2.x code will have to be updated to use DAO 3.x syntax. That's not
technically difficult, but it is something of a chore.
--
Brendan Reynolds (MVP)

troy said:
Where can i find or what is the step to Migrate an Access 2.0 database to
XP? I would like to find information on how to do this and what type of
problems that may arise duing the conversion process. any help is greatly
appreciated. Also is there 3rd party tools to help with this process/
 
T

Tony Toews

troy said:
Where can i find or what is the step to Migrate an Access 2.0 database to XP? I would like to find information on how to do this and what type of problems that may arise duing the conversion process. any help is greatly appreciated. Also is there 3rd party tools to help with this process/

In addition to Arvin and Brendan's comments see
Access 2.0 and Access 97 to Access 2000/2002 conversion problems
http://www.granite.ab.ca/access/conversionproblems.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top