Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2004
    Location
    Leicester, Leicestershire, England
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Visual Basic Ver.6 (MS Visual Basic 6)

    How can I get Vb6 to read/use a database file from Access?
    I should like also to to get Access to read VB database files without have to convert them first.

    Tony

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Visual Basic Ver.6 (MS Visual Basic 6)

    > How can I get Vb6 to read/use a database file from Access?

    You can use ADO (ActiveX Data Objects) to read and write MDB files. Since I don't use Visual Studio, I don't know whether it contains a convenient wizard for that or whether you need to code it by hand.

    > I should like also to to get Access to read VB database files without have to convert them first.

    While you cannot open a different-format database in Access without a convert/open prompt, you can open a database that links to a different-format MDB without any complaints. So, if you need to create an MDB in a format different than your current version(s) of Access, I suggest creating one or more intermediary files for the Access users that link to your tables.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Visual Basic Ver.6 (MS Visual Basic 6)

    It's another reason for splitting the Access database into a front-end and a back-end. That way you can work with the data in either environment. VB is split to begin with, so leave your back-end in that format as Jefferson suggests, and do you front-end in the version of Access that you have. If you want more details on how to do that see Why Split a Database?.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •