Converting from Access 1.X

  • Thread starter Thread starter Greg Hatfield
  • Start date Start date
G

Greg Hatfield

While attempting to convert an older Access Database to
Access 2002 I get an error saying the conversion doesn't
work for Access Version 1.X. Is there any way to convert
this file? I didn't build this DB and can't even open it
on my system. Thanks
 
why dont you try to build a new database and import all
the objects from the old database?
 
Find someone with a copy of Access 2.0, and get them to convert, then open
the Access 2.0 database in a later version... I _think_ Access 2002 will
still convert a 2.0 database. I know Access 97 and 2000 will. If any APIs
were used, you'll have to convert the 16-bit API calls to the corresponding
32-bit API calls. There will be some other manual modifications required,
but the number is not great.

If you can't find someone with Access 2.0, you may be able to purchase a
copy at some of the "old software" or auction sites. When a similar question
came up a year or so ago, that's what the poster did -- found a copy of
Access 2.0, still in shrinkwrap, for $15 on eBay. I hasten to point out
that, with auction sites, your mileage may vary.

Larry Linson
Microsoft Access MVP
 
it will be a steep hill anyway provided code a la
Docmd A_MENU..
type of code

;-) Pieter
 
Unfortunately, 2002 will not convert a 2.0 database. But it will convert a
97 one. So the progression will need to be:

1.x > 2.0 > 97 > 2002

or

1.x > 2.0 > 2000 > 2002

He will need a copy of 97/2000 for the Extensibility layer (for the
DoMenuItem code) which may be on the 2002 disk as well. Access Basic will
need to be changed to VBA before it will compile.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Arvin Meyer said:
Unfortunately, 2002 will not convert a 2.0 database. But it will convert a
97 one. So the progression will need to be:

1.x > 2.0 > 97 > 2002

or

1.x > 2.0 > 2000 > 2002
Click to expand...

FWIW A97 online help indicates it can convert a 1.x MDB

"In most cases, you will want to convert Microsoft Access version 1.x
or 2.0 databases to Microsoft Access 97. Although you can enable a
version 1.x or 2.0 database in Microsoft Access 97 without converting
it, you can neither change the design of objects in that database nor
take advantage of many of the new features in Microsoft Access 97
until you convert the database. "

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
 
Back
Top