+ Reply to Thread
Results 1 to 3 of 3

Thread: Visual Basic + Microsoft Access

  1. #1
    Zenax's Avatar
    Zenax is offline Lord Of The Keys Zenax is an unknown quantity at this point
    Join Date
    Jul 2006
    Location
    The Brilliant United Kingdom
    Posts
    1,339

    Visual Basic + Microsoft Access

    Hey i was wondering if any of you have any experience with Visual Basic and Microsoft Access.

    I am trying to create a database driven application from Visual Basic using a MS Access DB. Except I get an error.

    Error Code 3343: This is an unrecognized database format.

    Any ideas on how to fix this?

    --
    Zenax
    Regards,
    Zenax

  2. #2
    Micro is offline Retired staff (11-12-2008) Micro is an unknown quantity at this point
    Join Date
    Jul 2006
    Location
    West Midlands
    Posts
    1,301

    Re: Visual Basic + Microsoft Access

    Incorrect Versions / File Corruption is the cause of this error.. Hmm.. Dont know otherwise Also, which version of VB are you using?
    Micro

  3. #3
    Zenax's Avatar
    Zenax is offline Lord Of The Keys Zenax is an unknown quantity at this point
    Join Date
    Jul 2006
    Location
    The Brilliant United Kingdom
    Posts
    1,339

    Re: Visual Basic + Microsoft Access

    I am using Visual Basic 6.0 with Microsoft Access 2000

    Looking up on the internet I fount this code:

    Code:
    Option Explicit
    Private daoDB36 As Database
    Private rs As DAO.Recordset
    Dim sPath As String
    
    Private Sub Form_Load()
    sPath = _
    "path of database here"
    Set daoDB36 = DBEngine(0).OpenDatabase(sPath)
    Set rs = daoDB36.OpenRecordset("Customers")
    Set Data1.Recordset = rs
    End Sub
    This code was the microsoft website, but it does not work.
    Website: http://support.microsoft.com/kb/238401

    So any ideas people?

    --
    Zenax

    EDIT: it works on my college version of Visual Basic but not at home, and I swear they are the same version. Perhaps cuz at college I am using MS Access 2003 where Im using 2000 at home

    EDIT 2: I have tried reparing/compressing the DB at home but to no avail!
    Last edited by Zenax; 03-01-2007 at 03:39 AM.
    Regards,
    Zenax

+ Reply to Thread

Similar Threads

  1. Using Visual Basic 2005
    By TheJeffsta in forum Scripts & 3rd Party Apps
    Replies: 3
    Last Post: 08-05-2006, 02:18 PM
  2. Palm, Microsoft forge peace with handheld
    By Brandon in forum Crossfire
    Replies: 0
    Last Post: 09-27-2005, 06:40 PM
  3. Visual Basic for Free?
    By AsPeRiTy in forum Scripts & 3rd Party Apps
    Replies: 9
    Last Post: 08-15-2005, 08:24 PM
  4. Visual Basic 6.0
    By spyrorocks in forum Scripts & 3rd Party Apps
    Replies: 27
    Last Post: 06-25-2005, 03:56 AM
  5. Visual Basic: An introduction Part 1
    By thegoodlist in forum Tutorials
    Replies: 0
    Last Post: 06-08-2005, 11:00 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers