TechRepublic|Forums|Web Development

Web Development

General discussion

  • Creator
    Topic
  • December 22, 2004 at 12:54 am #2292938

    how to change database version?

    Locked

    by khalid · about 19 years, 4 months ago

    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?

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Comments

  • Author
    Replies
    • December 22, 2004 at 6:31 am #3300602

      Reply To: how to change database version?

      by bfilmfan · about 19 years, 4 months ago

      In reply to how to change database version?

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

    • December 28, 2004 at 6:09 am #3318153

      Reply To: how to change database version?

      by dushy_ant · about 19 years, 3 months ago

      In reply to how to change database version?

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

    • December 28, 2004 at 7:11 am #3318146

      Reply To: how to change database version?

      by khalid · about 19 years, 3 months ago

      In reply to how to change database version?

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

    • January 3, 2005 at 5:55 am #3298498

      Reply To: how to change database version?

      by techrep · about 19 years, 3 months ago

      In reply to how to change database version?

      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.

    • January 12, 2005 at 1:02 am #3346198

      Reply To: how to change database version?

      by khalid · about 19 years, 3 months ago

      In reply to how to change database version?

      This question was closed by the author

  • Author
    Replies
Viewing 4 reply threads