Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Conversion / October 2006

Tip: Looking for answers? Try searching our database.

Batch Conversion from Access 97 to Access XP

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Michael Foitzik - 07 Aug 2006 10:46 GMT
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 - 07 Aug 2006 12:49 GMT
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/details.aspx?FamilyId=2E861E76-5D89-450A-B977
-980A9841111E&displaylang=en


Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Hi,
>
[quoted text clipped - 6 lines]
>
> Michael
Michael Foitzik - 08 Aug 2006 09:35 GMT
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

> 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
[quoted text clipped - 4 lines]
> 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/details.aspx?FamilyId=2E861E76-5D89-450A-B977
-980A9841111E&displaylang=en


> > Hi,
> >
[quoted text clipped - 6 lines]
> >
> > Michael
Tony Toews - 09 Aug 2006 06:26 GMT
>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
Signature

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 - 10 Oct 2006 23:04 GMT
> Hi,
>
[quoted text clipped - 6 lines]
>
> Michael
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.