PDA

Click to See Complete Forum and Search --> : Unrecognized Database format


jay19n64
Mar 16th, 2000, 09:35 AM
I have VB6 and Access 2000, I made a little database(first one) linked it to a data control button and when I link the DatabaseName it is ok, but when I try to set the RecordSource it gives me the error "Unrecognized Database format c:\mydocuments\price.mdb"
Thanks in advance
Jason

Clunietp
Mar 16th, 2000, 09:45 AM
http://support.microsoft.com/support/kb/articles/q238/4/01.asp?LNG=ENG&SA=ALLKB

jay19n64
Mar 16th, 2000, 09:59 AM
I put the code below in and it does the same thing, do I change the code anywhere o0ther than the database path.

Option Explicit
Private daoDB36 As Database
Private rs As DAO.Recordset
Dim sPath As String

Private Sub Form_Load()
sPath = _
"C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb"
Set daoDB36 = DBEngine(0).OpenDatabase(sPath)
Set rs = daoDB36.OpenRecordset("Customers")
Set Data1.Recordset = rs
End Sub