Results 1 to 3 of 3

Thread: Unrecognized Database format

  1. #1

    Thread Starter
    New Member
    Join Date
    Mar 2000
    Posts
    14
    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

  2. #2
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844
    http://support.microsoft.com/support/kb/articles/q238/4/01.asp?LNG=ENG&SA=ALLKB

  3. #3

    Thread Starter
    New Member
    Join Date
    Mar 2000
    Posts
    14
    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
  •  



Click Here to Expand Forum to Full Width