By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,501 Members | 2,681 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,501 IT Pros & Developers. It's quick & easy.

Workgroup MS Access 2003 Windows XP

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.