VB & Database, problems connecting access2000 db

problems connecting access2000 db

Author	Message
eran #1 / 3	problems connecting access2000 db hi there ,just started ado & i cant anderstand why when i use an .mdb file of access 97 i have no problem connecting the db , but when i create a new db file in access 2000 i get an error "unrecohnized database format ..'name of file'" this is the code: "Public dbDATA As ADODB.Connection Public Sub OpenDB() Set dbDATA = New ADODB.Connection dbDATA.Open "provider=microsoft.jet.OLEDB.3.51;Data Source=d:\eranvb\shai\Shaidb.mdb" End Sub" i hope someone can get me out of one thenks eranb
Fri, 26 Sep 2003 08:37:26 GMT

Halstein Tonhei #2 / 3	problems connecting access2000 db Quote: > hi there ,just started ado & i cant anderstand why when > i use an .mdb file of access 97 i have no problem connecting > the db , but when i create a new db file in access 2000 > i get an error "unrecohnized database format ..'name of file'" > this is the code: > "Public dbDATA As ADODB.Connection > Public Sub OpenDB() > Set dbDATA = New ADODB.Connection > dbDATA.Open "provider=microsoft.jet.OLEDB.3.51;Data > Source=d:\eranvb\shai\Shaidb.mdb" <snip> With Access 2000 you have to use Jet 4.0. 3.51 is the one for Access 97. Try dbDATA.Open "provider=microsoft.jet.OLEDB.4.0;Data Source=d:\eranvb\shai\Shaidb.mdb" Regards, Halstein Tonheim
Fri, 26 Sep 2003 01:10:40 GMT

Garry Marti #3 / 3	problems connecting access2000 db change 3.51 to 4.0 Garry www.silvermaine.co.uk
Fri, 26 Sep 2003 05:01:18 GMT

Page 1 of 1

[ 3 post ]