Web Development

Ask something
Discussion Locked

how to change database version?

0 helpful
8 replies

by khalid

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have Viusal basic program with Microsoft Access 2000 Database using (Ado) and I want to change the version of the DB to Access 97
I try compactdatabase method but it's not working with me so what can I do?

8 replies

by dushy_ant

Open Access File
Goto Tools menu -> Database Utiliities ->
Convert Database -> To Prioir Database Version.

This will create a new data base withh all facilities (provided they are supported in the previous version. )

So also you will have to change the connection string of ADO, connection class, so that it connects to the prior version of the database.

THe provider version for access 97 database is 3.51 instead of 4.0(as in Access 2000).

by khalid

I want to change the database version from VB I mean using visual Basic code not from Microsoft Access

by techrep

You cannot change the database from within Visual Basic. That is not possible. You are using an Access database, You have to use Access to change it.

This discussion is closed to new replies.