|
-
Mar 16th, 2000, 10:35 AM
#1
Thread Starter
New Member
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
-
Mar 16th, 2000, 10:45 AM
#2
Guru
http://support.microsoft.com/support/kb/articles/q238/4/01.asp?LNG=ENG&SA=ALLKB
-
Mar 16th, 2000, 10:59 AM
#3
Thread Starter
New Member
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|