Connect to workgroup file (mdw) thru code

[gazelle04]

Can I connect to a workgroup information file (MDW) thru code?

I have a user level secured database and I want to automatically connect to the mdw file once I double clicked the database. Is it possible?

My purpose is to hide the mdw file from the user although I have given them access to it. I don't want them to know the location of the mdw file so I would like it to hide thru code in Access. There are password cracker software (even crack the mdw file) available on the internet for a small amount of 40 US$ you could break all the secured access database in the world.

Thanks,

[ADezii]

Can I connect to a workgroup information file (MDW) thru code?

I have a user level secured database and I want to automatically connect to the mdw file once I double clicked the database. Is it possible?

My purpose is to hide the mdw file from the user although I have given them access to it. I don't want them to know the location of the mdw file so I would like it to hide thru code in Access. There are password cracker software (even crack the mdw file) available on the internet for a small amount of 40 US$ you could break all the secured access database in the world.

Thanks,

You can use the /wrkgrp <WIF Path> Command line Option within a Shortcut to open an Access Database using the specified Workgroup Information File but unfortunately there isn't much Security in this approach unless you can disable the Shortcut View.

[gazelle04]

Thanks Adezii,

Right now I'm using a shortcut that displays the location of the mdw file. This is the reason why I want to know if there is a code I could use that could connect to a mdw file at start up from the form I would use as a start up.

[ADezii]

Thanks Adezii,

Right now I'm using a shortcut that displays the location of the mdw file. This is the reason why I want to know if there is a code I could use that could connect to a mdw file at start up from the form I would use as a start up.

Personally, I've never used it, but you can experiment with the SetDefaultWorkgroupFile Method of the Application Object as in:

'The following example sets the default Workgroup file to the File
'Test.mdw in the directory C:\Documents and Settings\Security\
'Application Data\Microsoft\Access\.
 
Application.SetDefaultWorkgroupFile _
  path:="C:\Documents and Settings\Security\" _
  & "Application Data\Microsoft\Access\Test.mdw"

NOTE: It may not be practical in your case, since you would probably have to Close, then Re-open the Database in order to be effective.