Convert Database Programmatically

[Guest]

I have a front-end and back-end database which are linked. I want the user
of this database to be able to run a script (macro) from the front-end
database which would make a copy of the back-end DB, then convert it from
MSAccess 2003 to MSAccess 2000. Does anyone know how to do this
programmitically?

Any help is appreciated.

Thank you,

Sarah

 

[Stefan Hoffmann]

hi Sarah,

I have a front-end and back-end database which are linked. I want the user
of this database to be able to run a script (macro) from the front-end
database which would make a copy of the back-end DB, then convert it from
MSAccess 2003 to MSAccess 2000.

Why would you like to do this?

As long as you are using linked tables, it is not important of which
format your back-end is, because the linked tables are managed by Jet.
And Jet can handle this.

mfG
--> stefan <--

 

[Guest]

Yes you are correct. Although I have a user who needs the MS2003 back-end in
MS2000. Since he is working in MS2000. The original database was created in
MS2003. I don't think a MS2003 back-end would work in MS2000.

 

[mcescher]

Why don't you just convert it to 2000, and have the other users open it
with 2003.
Besides, he would have to have 2003 to convert it from 2003 to 2000.

HTH,
Chris