Using OpenCurrentDatabase Method with /wrkgrp Parameter

[DDJ]

Based upon previous posts to this newsgroup, we are trying to figure a way
to open (using VB6 code) a non-password protected Access 2000 database AND
pass the location of the mdw file. We want our users to be able to open the
database in Access and modify various objects, etc. We're using code
similar to the following:

objAccess.OpenCurrentDatabase sDataSource & "\WCData.mdb", False
objAccess.DoCmd.Maximize
objAccess.Visible = True

Is there any way to use the OpenCurrentDatabase method in VB6 AND pass the
location of the mdw file? We are only trying to pass the workgroup info
argument because some of our users are having problems with the above code
(so we understand that we need to ship an mdw file with the product).

Dan

 

[Joan Wild]

I don't believe so. You could use the OpenDatabase method. You would do
this after creating a separate workspace.

Check section 46 of the security FAQ for an example.
http://support.microsoft.com/?id=207793