Returning Workgroup name in Access 1

[afryer]

Hi All,

I am running an application, which uses a command line to connect to a user-defined workgroup file. I need to check at startup to make sure they have connected using the command line and not simply double-click on the application name. Does anyone know of a way (in VBA) to return the the name of the Workgroup that the database is connected to?

Thanks

 

[mp9]

If you have a reference to DAO set, you can use dbengine.SystemDB

http://www22.brinkster.com/accessory/

 

[PHV]

I don't think you need any special reference to use the following:
Application.DBEngine.SystemDB

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mp9]

On reflection, I think you're probably right there PHV.

http://www22.brinkster.com/accessory/