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:
Access is NOT listed as a Reference in Project ReferencesCode: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
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???




Reply With Quote