Access Workgroup Help

[anoyse]

I have this db that I developed and built and I'm a member of th
ADMINS group. When I log into it to try and set up groups & user
it tells me that I need to be part of the ADMINS group to set u
groups. When I print out all users & the groups they belong to
am part of the ADMINS group. I have administer rights to the db i
all of the permissions. It won't let me run the security wizar
either

I think it has something to do with a workgroup file that's on my pc
but I don't know how to find which one is the one it's using and ho
to
modify it. I thought about creating another workgroup but I'm afrai
it will try to replace my start up system.mdw file.

The db resides on a network drive so I tried to open it from anothe
workstation under my id. I couldn't because it couldn't find th
right files to open it. However, I had a coworker open it at he
workstation under her id and she is logged in as ADMIN under ADMIN
with full permissions

The kicker is when I create a new blank db I don't have permission t
do anything to that one either. According to the workgrou
administrator my startup workgroup is the system.mdw so I'm not sur
what's going on

The good news is I can salvage my db and if worse comes to worse ge
someone else to secure it. The bad news is I can't do it at m
workstation or under my id. Any ideas? :

 

[Guest]

Hello Anoyse,

I think it has something to do with a workgroup file that's on my
pc but I don't know how to find which one is the one it's using...

From the Immediate window (Ctrl + G) issue the following command:

? application.DBEngine.SystemDB or
? DBEngine.SystemDB (shorthand)

The kicker is when I create a new blank db I don't have permission
to do anything to that one either. According to the workgroup
administrator my startup workgroup is the system.mdw so I'm not
sure what's going on.

It sounds like you have inadvertently modified your copy of System.mdw.
After locating the copy of System.mdw that you are using (you may have more
than one copy on your PC), close Access. Then find the file and rename it to
something like System.old. Restart Access. A new System.mdw file should be
created automatically for you, if Access cannot find the copy that it expects
to find. This should restore your ability to work with new databases.

I suggest you read as much as you can on Access security. Here are several
good links for you:
http://www.ltcomputerdesigns.com/JCReferences.html#Security


Tom
______________________________________

:

I have this db that I developed and built and I'm a member of the
ADMINS group. When I log into it to try and set up groups & users
it tells me that I need to be part of the ADMINS group to set up
groups. When I print out all users & the groups they belong to I
am part of the ADMINS group. I have administer rights to the db in
all of the permissions. It won't let me run the security wizard
either.

I think it has something to do with a workgroup file that's on my pc
but I don't know how to find which one is the one it's using and how
to modify it. I thought about creating another workgroup but I'm afraid
it will try to replace my start up system.mdw file.

The db resides on a network drive so I tried to open it from another
workstation under my id. I couldn't because it couldn't find the
right files to open it. However, I had a coworker open it at her
workstation under her id and she is logged in as ADMIN under ADMINS
with full permissions.

The kicker is when I create a new blank db I don't have permission to
do anything to that one either. According to the workgroup
administrator my startup workgroup is the system.mdw so I'm not sure
what's going on.

The good news is I can salvage my db and if worse comes to worse get
someone else to secure it. The bad news is I can't do it at my
workstation or under my id. Any ideas? :?