General discussion

Locked

how to change database version?

By khalid ·
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?

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by BFilmFan In reply to how to change database ve ...

A very large thread on the methods needed to accomplish that here:
http://www.tek-tips.com/viewthread.cfm?qid=41222&page=1

Collapse -

by khalid In reply to

I am using VIusl Basic not access

Collapse -

by Dushy_ant In reply to how to change database ve ...

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

Collapse -

by khalid In reply to

I want to change the database version from Viusal Basic not from access

Collapse -

by khalid In reply to how to change database ve ...

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

Collapse -

by techrep In reply to how to change database ve ...

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.

Collapse -

by khalid In reply to

I am using VIusl Basic not access

Collapse -

by khalid In reply to how to change database ve ...

This question was closed by the author

Back to Web Development Forum
8 total posts (Page 1 of 1)  

Related Forums