|
Home > Archive > MS Access data conversion > April 2005 > multi-databases Access 2.0 to 97 conversion
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
multi-databases Access 2.0 to 97 conversion
|
|
|
| Hi,
I have to convert ~100 access2.0 databases to access97
these databases contain only tables (no queries, no reports)
somebody would have a solution, code example, to automate this process ?
i try using the command line, but i don't know how to manage errors.
Thanks for your help.
TwoD
| |
| david epsom dot com dot au 2005-04-06, 8:05 pm |
|
dim dbe as dao.dbEngine
if dir(sNewDBFullPath) <> "" then kill sNewDBFullPath
dbe.CompactDatabase sOldDBFullPath, sNewDBFullPath, dao.dbLangGeneral,
dao.dbVersion30
if dir(sNewDBFullPath) <> "" then
kill sOldDBFullPath
FileCopy sNewDBFullPath, sOldDBFullPath
endif
This affects only the version of the data format of newdb and doesn't affect
the version of any Microsoft Access-defined objects, such as forms and
reports. You will no longer be able to open the files in Access 2.0. You
will still see the Access 'conversion' dialog the first time you open the
files in Access 97, even if there are no Access objects to convert.
Access 95 (Jet 3.0) and Access 97 (Jet 3.5) both used the Version30 file
format.
(david)
"TwoD" <user@host.com> wrote in message
news:d0k4pm$hi2$1@s1
.news.oleane.net...
> Hi,
>
> I have to convert ~100 access2.0 databases to access97
> these databases contain only tables (no queries, no reports)
>
> somebody would have a solution, code example, to automate this process ?
>
> i try using the command line, but i don't know how to manage errors.
>
> Thanks for your help.
>
> TwoD
|
|
|
|
|