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
--
Joan Wild
Microsoft Access MVP

Post by 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,
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