Connecting to a workgroup

[nxqviet]

Hi all,

I have an access file that is placed on a share drive that allow
multiple user to use it at the same time. This file suppose to be
linked to a workgroup for security purposes.

But whenever we have new users, they all have to manually connect to
the workgroup by going to Tool\security\workgroup...

Is there any way to make the connectiong automatic? because the users
are not allow to see the tool bar, so they can't make this workgroup
connection by going to Tool... I would have to do it for them
everytime.

Thanks,

V_

 

['69 Camaro]

Hi.

I have an access file that is placed on a share drive that allow
multiple user to use it at the same time.

Is it a single file that everyone is sharing, or is it a split database,
with the back end (tables and relationships) database on the network server,
and a copy of the front end (queries, forms, reports, et cetera) on each
user's workstation?

But whenever we have new users, they all have to manually connect to
the workgroup by going to Tool\security\workgroup...

To make life easier, they shouldn't join the secure workgroup. They should
remain joined to the default workgroup and use a Windows shortcut to open
the secure database with the secure workgroup file. This is the syntax for
the shortcut: (watch out for word wrap, as this is all one line)

"<Full path to Office>\MSAccess.EXE" "<Full path to DB>\MyDB.MDB" /wrkgrp
"<Full path to secure workgroup>\Secure.MDW"

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.