Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VB and Access (VB6)

    New to Visual Basic and I am not clear on VB and Access.

    Is the ability to create .mdb files shipped with VB or does the end-user have to have Access on their system?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: VB and Access (VB6)

    You can use DAO or ADOX to create a database. See Creating an Access Database for ADOX; you need to set a reference to the "Microsoft ADO Ext. 2.7 for DDL and Security" library (msadox.dll).

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VB and Access (VB6)

    VB 6 includes the Jet database engine. If you have VB6 professional, you can create and distribute an application that includes a Jet mdb file as a data store.
    Charlotte

  4. #4
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VB and Access (VB6)

    Thanks Hans and Charlotte for the info.

    I am familiar with Access 97 security. In VB6, if by including a Jet mdb file as a data store, will security work in the VB app much as it does in Access? If not what options are available to secure a VB app?

    Thanks

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: VB and Access (VB6)

    Whether you use Access itself or VB6, you are actually using the Jet database engine to retrieve and store data in the database. Security is an integral part of the Jet engine; if you apply user-level security (through a secured workgroup information file) to the database, this will be in force whatever method you use to connect to the database.

Posting Permissions

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