Batch Conversion from Access 97 to Access XP

[Michael Foitzik]

Hi,

im looking for a tool, which is able to scan directories for Access files
and converts them from Access97 to Access XP.

Thanks in advance for your help

Regards


Michael

 

[Douglas J. Steele]

Automating conversions is seldom a good idea: if nothing else, you still
need to test each database to ensure that it works in the new version, so
that the actual time required to open the database in the new version and
have it convert is an insignificant amount of time overall.

While I know you say you're using Access 2002, you might still benefit from
the Access 2003 Conversion Toolkit (since, by default, both Access 2002 and
Access 2003 use the same Access 2000 file format)

http://www.microsoft.com/downloads/...76-5D89-450A-B977-980A9841111E&displaylang=en

 

[Michael Foitzik]

Thanks for your resposnse.

we already made a test conversion for the most important databases, and it
works fine with Access XP, but converting the databases by opening and
saving in the the new format again, is time-consuming. There are also
hundreds of other databases, that won't be a problem for the conversion, but
also have to be converted.

Regards

Michael

 

[Tony Toews]

im looking for a tool, which is able to scan directories for Access files
and converts them from Access97 to Access XP.

Code it yourself.

You can use DIR, or an API call, to loop through a directory or a set
of directories.

You can use the following tool to help you convert MDB from A97 to
A2002.
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=6#6

Then you can use some code on the references to clean up the useless
items such as the VBIDE or the OWC.

Dim ref As Reference

For Each ref In Access.References
If ref.Name = "VBIDE" Or ref.Name = "OWC10" Then
References.Remove ref
End If
Next ref

Then see if it will compile

Call Access.SysCmd(504, 16483)

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

 

[Bob Rellstab]

Hi,

im looking for a tool, which is able to scan directories for Access files
and converts them from Access97 to Access XP.

Thanks in advance for your help

Regards


Michael