Mass Conversion of Access 97 files to Access 2000


P

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
 
Ad

Advertisements

A

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?
 
R

Rick Brandt

Philip said:
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.
 
P

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.
 
P

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.
 
Ad

Advertisements

A

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.
 
Ad

Advertisements


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