Results 1 to 20 of 20

Thread: [RESOLVED] How Does VB I Want to Use MSAccess

Threaded View

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Jul 2001
    Location
    Tucson, AZ
    Posts
    2,166

    Resolved [RESOLVED] How Does VB I Want to Use MSAccess

    I'm trying to create multiple instances to MSAccess.
    In doing so it raised the above question of "How Does VB Know I Want to Use MSAccess?".

    --------------------------
    I currently use Access by:

    Code:
       Public Declaration
       Public DaoDb As DAO.Database
       Public accApp As DAO.Database      '<<Ignore this for now
    
       'Procedure Code of Interest
      'Get DaoDb location, name, and open it
      'This returns an Access *mdb file
       strPath = MCommon.GetPath(PATH_DB)
       
       'Open Database
       '-- DaoDB defined globally
       '-- Parameters  (There are other options not used)
       '   -- strPath of DB
       '   -- How Opened {True = Exclusive, False = Shared}
       '   -- Access Method, {False = Read-Write, True = ReadOnly})
       'Opening in Exclusive Mode does NOT allow other instances
       'of VB to gain access to the database
       Set DaoDb = OpenDatabase(strPath)   ', True, False
    Access is NOT listed as a Reference in Project References
    Name:  VBProject.bmp
Views: 408
Size:  197.7 KB

    so How does VB know I want to use MsAccess?

    //////////////////////////////

    To further confuse myself, after running the above code and looping the processes in task manager,
    Access does not even show up as a running process.

    What gives???
    Last edited by dw85745; Jan 12th, 2013 at 02:53 PM.

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