Data Control - Access 97 to Access 2000

I have a VB 6.0 project that was originally written using an Access 97 database. I am trying to convert the app to use Access 2000. The only thing I can find that does not work is the "Data" control. It reports an error "Unrecognized database format...". There is nothing in the control properties to change to make it recognize the database is now an Access 2000 database. Does anyone have any suggestions as to how to make this problem bother someone else?

This is really an irritating problem.

thanks for any help!!
-Lee

Comments

  • : I have a VB 6.0 project that was originally written using an Access 97 database. I am trying to convert the app to use Access 2000. The only thing I can find that does not work is the "Data" control. It reports an error "Unrecognized database format...". There is nothing in the control properties to change to make it recognize the database is now an Access 2000 database. Does anyone have any suggestions as to how to make this problem bother someone else?
    :
    : This is really an irritating problem.
    :
    : thanks for any help!!
    : -Lee
    :
    :

    Set provider to 'Microsoft.Jet.OLEDB.4.0' (see below)
    Bye


    Connectstring (Provider for Access 97 and earlier):

    Provider=[b]Microsoft.Jet.OLEDB.3.51[/b];Persist Security Info=False;User ID=Admin;
    Data Source=c: est97.mdb;Mode=Share Deny None;Extended Properties=";
    COUNTRY=0;CP=1252;LANGID=0x0409";
    Jet OLEDB:System database="";Jet OLEDB:Registry Path="";
    Jet OLEDB:Database Password="";Jet OLEDB:Global Partial Bulk Ops=2


    Connectstring (Provider for Access 2000 and earlier):

    Provider=[b]Microsoft.Jet.OLEDB.4.0[/b];Password="";User ID=Admin;
    Data Source=c: est.mdb;Mode=Share Deny None;Extended Properties="";
    Jet OLEDB:System database="";Jet OLEDB:Registry Path="";
    Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=4;
    Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;
    Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";
    Jet OLEDB:Create System Database=False;
    Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;
    Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion