CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Guest

    Access 2000 and VB6

    Sorry if this has been answered before but can VB6 w/ SP3 handle Access 2000 database files? I get an error saying unrecognized database format.

    Thanks!


  2. #2
    Join Date
    Apr 1999
    Location
    Brooklyn, NY USA
    Posts
    171

    Re: Access 2000 and VB6

    You cannot use Data Control directly with new format, but you can create DAO (using DAO360.dll)or ADO recordset. If you must use Data Control for some reason (I had a such situation) you need create DAO recordset and assign it as recordset to Data Control:
    Dim db as Database
    Dim rsMyRecordset as Recordset
    Set db = OpenDatabase("Name")
    Set rsMyRecordset = db.OpenRecordset("SELECT * FROM ...", dbOpenDynaset)
    Set Data1.Recordset = rsMyRecordset
    HTH
    Vlad Chapranov, MCP


  3. #3
    Join Date
    Sep 1999
    Posts
    1

    Re: Access 2000 and VB6

    Hi,
    Change DAO Library 3.6 to 3.0 or 3.5 ok


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

Featured