Access version conversion

[dcarlson]

Is it possible to convert an Access 2000 database to Access 97 using VB code?

Ok there is no way you can automatically do this

Open both databases, and unfortunately read the data from each recordset in the 2000k database and write it to the 97 database.

Just finished adding this facility to our product. Access is about the only office app that doesn't have an export to previous version option.

Ours worked well....but....be careful of new data types in 2000, we didn't have this problem...but...it may be the case

[dcarlson]

Thanks, but if that's the case I won't even bother. The database that I developed uses an Access 2000 database and my client has Access 97, so all I wanted to do was have them be able to open the database in Access 97.

Access97 will definitely not open Access2000 mdbs.

Spent four hours writting the conversion utility to add to our product...complete waste of time....but at least the client was happy with us

[PaulLewis]

Although I didn't write an app that required the user to have Access 97 or Access2000, I have written an App that relies on the user having OLEDB3.51 or OLEDB4.0 available. I realise that OLEDB4.0 gets installed as part of Office 2000 (regardless of whether Access2000 is installed) so I was wondering if you guys know what (if anything) I can include in my distribution that will "upgrade" the customer to OLEDB4.0?

My solution to date is to use an Access97 format DB and then the user can use either OLEDB3.51 or OLEDB4.0. Ideally, I'd like to detect all that for the user and offer an upgrade to OLEDB4.0. Then I could use Access 2000 format DB (its a standalone app).

Any thoughts or clues?

Paul Lewis

[windsurfkid]

Is it possible to convert an Access 2000 database to Access 97 using VB code?

It is possible to convert an Access DB from 2000 to 97, by adding the following reference to your project - Microsoft Access 11.0 Object Library

Then create a function like so, you may want to put some exception handling in to check the DB is not open, and that the 2000 file exist and the 97 doesn’t etc.

Public Function ConvertDB(SourcePath As String, DestinationPath As String)
 
    Dim AccessObj As New Access.Application
 
    AccessObj.Application.ConvertAccessProject SourcePath, DestinationPath, acFileFormatAccess97
    
    Set AccessObj = Nothing
 
End Function

[randem]

dcarlson,

Are you just attempting to convert data or Access code? If just data, Yes. But why? Are you coding in Access or VB. For VB doesn't need Access to connect to the tables and you can use any version of Access database you like.

[d3gerald]

theres no way you can convert an ms2000 access file to 97. but if you're just trying to access it from your prog, you need not to do that.

[randem]

You can convert an Access 2000 mdb to an Access 97 mdb (Data Only).

[wiz126]

windsurfkid, Why in the world would you BUMP a 6!!! years old thread? it would be so much easer to just make a new one.....

Anyway, d3gerald you can convert the data from 2000 to97

[randem]

I guess he can't be acused of not searching first!!!!

[lerroux]

does this mena that this 6 years old thread is not yet resolved? well here's what i think... for an access 2000 to 97 file... NO... for data only... YES... RESOLVED! now wasn't that easy...

[wiz126]

look at this: http://office.microsoft.com/en-us/as...381541033.aspx
there are going to be many problems converting it back from 2000 to 97.

[d3gerald]

yeah i know that you can convert the data but not the file format itself

[randem]

What?????