VB Forum / General 2 / December 2004

i tried using the following code using a database originally created in
access97 and updated to 2000.

when i ran the code i got the error msg at the end of posting.  however when i
tried using a 2 year old backup still in 97 format it worked.

i appreciate any help

howard

oh yes in a previous post i got questions about books.  it's for discounts on
my comic sales.

Private Sub Form_Load()

Dim adoConnection As ADODB.Connection
Dim NjcSet  As ADODB.Recordset
Dim ConnectString As String

Set adoConnection = New ADODB.Connection
Set NjcSet = New ADODB.Recordset

ConnectString = "provider=microsoft.jet.oledb.3.51;" _
   & "Data source=d:\NotJustComics\NjcInventory.Mdb"
   
adoConnection.Open ConnectString
NjcSet.Open "Comics", adoConnection

error message

Runtime Error '-2147467259(800040005)';
unrecognized database format 'd:\notjustcomics\njcinventory.mdb'