469,625 Members | 1,526 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,625 developers. It's quick & easy.

Workgroup MS Access 2003 Windows XP

Our company computers were recently upgraded to Windows XP with
Microsoft Office 2003. We have 3 different Access Databases (in
different directories on our network) which all require the user to be
part of a "Workgroup". It appears that Access 2003 includes some added
security features that prevent the user from accessing a database
unless you join the workgroup corresponding to the database. This works
fine, unless you need to join multiple workgroups. For example, to log
into database "x" you must join the "x" workgroup, and then to
log into database "y" you must join the "y" workgroup each time
you attempt to open it. So far, we have figured out how to join one
workgroup, but not many at the same time. We would greatly appreciate
it if anybody had advice regarding this issue.

Nov 13 '05 #1
3 4083
Easiest way is to use shortcuts, rather than joining the workgroup.

<full path to msaccess.exe> <full path to database> /wrkgrp <full path to
workgroup file>

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"JaBo" <fa*****@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
Our company computers were recently upgraded to Windows XP with
Microsoft Office 2003. We have 3 different Access Databases (in
different directories on our network) which all require the user to be
part of a "Workgroup". It appears that Access 2003 includes some added
security features that prevent the user from accessing a database
unless you join the workgroup corresponding to the database. This works
fine, unless you need to join multiple workgroups. For example, to log
into database "x" you must join the "x" workgroup, and then to
log into database "y" you must join the "y" workgroup each time
you attempt to open it. So far, we have figured out how to join one
workgroup, but not many at the same time. We would greatly appreciate
it if anybody had advice regarding this issue.

Nov 13 '05 #2
Br
JaBo <fa*****@gmail.com> wrote:
Our company computers were recently upgraded to Windows XP with
Microsoft Office 2003. We have 3 different Access Databases (in
different directories on our network) which all require the user to be
part of a "Workgroup". It appears that Access 2003 includes some added
security features that prevent the user from accessing a database
unless you join the workgroup corresponding to the database. This
works fine, unless you need to join multiple workgroups. For
example, to log into database "x" you must join the "x" workgroup,
and then to
log into database "y" you must join the "y" workgroup each time
you attempt to open it. So far, we have figured out how to join one
workgroup, but not many at the same time. We would greatly appreciate
it if anybody had advice regarding this issue.


Easy, just modify the shortcut used to call up each database to include
the specific workgroup file you are using for it...

"C:\Program Files\Microsoft Office 2000\Office\MSACCESS.EXE"
"C:\folder\FrontEnd.mdb" /wrkgrp "F:\sharedfolder\MyNewWorkgroup.mdw"

--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response
Nov 13 '05 #3
Doug and Bradley -

Thank you very much for your help. We were able to solve the issue
with your advice and now everybody is happy.

Thanks again - jabo

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Daniel | last post: by
3 posts views Thread by ajdfljsdf | last post: by
14 posts views Thread by Webbee | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.