Hiya, I need to know how to retrieve the path and name of the system file 

being used by a clients version of access.  I think it is an mda file, but 

I could be mistaken.



I need this to create a connection string to use with an ADODB connection 

from a VB dll.



I would very much appreciate any help.



Thanks.

Phillip

Try setting a reference to the lib "Microsoft Visual Basic for Applications

Extensibility" (on my machine this is version 5.3--your version may differ)

and looking at the References collection.  I don't know for sure if this

will suit, but it's worth a try.



HTH,



-Roy



Roy Pardee

Programmer/Analyst

SWFPAC Lockheed Martin IT

(xxx) xxx-xxxx



-----Original Message-----

From: Phillip Johnson [mailto:phillip.johnson@e...]

Sent: Saturday, October 20, 2001 10:41 AM

To: Access

Subject: [access] Access System File





Hiya, I need to know how to retrieve the path and name of the system file 

being used by a clients version of access.  I think it is an mda file, but 

I could be mistaken.



I need this to create a connection string to use with an ADODB connection 

from a VB dll.



I would very much appreciate any help.



Thanks.

Phillip

I believe what you're after is the WorkGroup file - if so here's how.



Function showMDW() As String    ' Name of the WorkGroup file for current

session

    showMDW = SysCmd(acSysCmdGetWorkgroupFile)

End Function



The ShowMDW function returns the fully qualified path of the the session

specific workgroup file.  

An MDW file is the Microsoft Database 'WorkGroup' information file

containing

permission information that is matched with group information within the MDB

file thus allowing user access to the database objects.  The name for the

default mdw file is SYSTEM.MDW.



MDA files are Microsoft Database 'Add-Ins' such as the various and several

wizards used by Access to ease and expedite object development.  



MDE files are encrypted (source-code-less) database applications usually

distributed where access the source code is inadvisable. 



Another creature is a Library database.  This can include your own custom

code

and objects - frequently referred to as the CodeDB.  An application can/will

use this file as the code to execute various (usually DAO) functions.  This

is

a separate that has just code (standard and/or class) modules and other

object

types.





Tom Hamilton

T_Systems, Inc

Database Programmer

(xxx) xxx-xxxx



>>> Phillip Johnson 10/20/01 10:41AM >>>

Hiya, I need to know how to retrieve the path and name of the system file 

being used by a clients version of access.  I think it is an mda file, but 

I could be mistaken.



I need this to create a connection string to use with an ADODB connection 

from a VB dll.



I would very much appreciate any help.



Thanks.

Phillip

Thanks for your help, I should be able to do it now.



Regards, Phillip