Mass Conversion of Access 97 files to Access 2000

[Philip Yeo]

Hi there,

Because access 97 is no longer supported by MS, we're in the midst of
planning to converting all our Access97 files to Access 2000. However
there are currently 1000 files to be converted. Is there any application
that can mass convert these files without having to go through the MS
Access application??? Appreciate the help..

Cheers,
Philip

 

[Alex White MCDBA MCSE]

Very open question,

if you re just converting without changing any data structures, this can be
done with code, my preferred way would be

open existing database,
create a new database (Access 2000),
copy the objects via code.

this leaves your original db's intact (good idea!!!!!)

I would strongly recommend validating your data on the way through, as I
have found so much bad data during these conversions e.g. dates like
01/05/200 get these cleaned up, it will take longer as you will want to
process each record and validate the data.

I have to ask why is there a 1000 files to be converted, sounds like
something may need to be done to restructure the data?

 

[Rick Brandt]

Hi there,

Because access 97 is no longer supported by MS, we're in the midst of
planning to converting all our Access97 files to Access 2000. However
there are currently 1000 files to be converted. Is there any
application that can mass convert these files without having to go
through the MS Access application??? Appreciate the help..

Cheers,
Philip

Just curious... In all the years that Access 97 was "supported" by MS how many
times did you use that support? For me it was zero so the fact that it is no
longer there means exactly squat.

There are legitimate reasons to upgrade. I do not find "supported by MS" to be
one of them.

 

[Philip Yeo]

Well first of all I agree with you Rick. I never used MS support for
Access. However its not my call to convert the files. Its management,
and no matter how much reasoning I have given them, the insist that the
change is necessary.

 

[Philip Yeo]

Errmmm 1 question,
Do I used ADOX to create the new database. How do I programmatically
determine what time of database it turns out to be (2k or 2003) ??

As for the question of change,
Well, actually first of all the system I'm supporting was badly design
from the very beginning and it was created to connect to access 97
database, in which there's a need to create new access files every
month. So next months file is Jun2005.mdb. Consider the 10 modules and 7
years it was use, there's hundreds of files that needs to be converted.
The conversion is strictly management's policy, they don't want
non-supported elements in the company's enviroment.

 

[Alex White MCDBA MCSE]

Hi Philip,

Yes to ADOX

a few links for you

http://www.freevbcode.com/ShowCode.Asp?ID=803

this one shows you how to specify the version of jet although it is
asp/vbscript it shows how to do it.

http://tutorials.programmingsite.co.uk/aspcreateaccess.php

but given that the default file format for Access 2000,2002,2003 is Access
2000 this should not be required.

ADOX relationship importer

http://support.microsoft.com/?kbid=304322

and some other stuff

http://www.codecomments.com/archive293-2005-3-436019.html

http://groups-beta.google.com/group...lr=&rls=GGLD,GGLD:2005-03,GGLD:en&sa=N&tab=wg

Sorry I have no examples that directly to the job, but as a pointer in the
right direction create a database, all this database is going to do is run
the import routines don't import/convert open databases.

Hope that little lot helps.