secured all databases can't administer

[Guest]

hel
i run the security wizard on access database and mistakenly overwrote the system.mdw file rather that a new one
i can get in using the user id & password i set up by admin no longer onws the objects and i cannot change owner as all users in both user & admins don't have administer priviledges

secondly all databases on my pc now require logon

how can i
1) secure only this database and unlock all ther others
2) change who can administer the databas

i'm new to this and need lots of help

col

 

[Joan Wild]

help
i run the security wizard on access database and mistakenly overwrote
the system.mdw file rather that a new one.
i can get in using the user id & password i set up by admin no longer
onws the objects and i cannot change owner as all users in both user
& admins don't have administer priviledges.

Who does own the objects? Can you sign in as that user? What makes you
certain that you overwrote the system.mdw file?

secondly all databases on my pc now require logon.

You are joined by default to a 'secure' workgroup file. Do a search on your
computer for all *.mdw files. You may find more than one. Post back with
the results.

how can i
1) secure only this database and unlock all ther others.
2) change who can administer the database

Certainly possible; one step at a time though; could you answer the
questions above?

 

[Colm O'Brien]

Who does own the objects?
Unknown

Can you sign in as that user? No

What makes you certain that you overwrote the system.mdw file?

when i ran the wizard i accepted the default setiing

You are joined by default to a 'secure' workgroup file. Do a search on your
computer for all *.mdw files. You may find more than one. Post back with
the results.

Security.mdw C:\Documents and Settings\colm\My Documents\Databases
SYSTEM.mdw C:\cquinn ltop\program files\microsoft office\office
SBCMTMPL.mdw C:\cquinn ltop\program files\microsoft office\office\SBT\SBCM

 

[Joan Wild]

Unknown

That indicates that the workgroup you are currently using, was not the same
one that was used to secure it with.

when i ran the wizard i accepted the default setiing

The default setting may have been 'create a new workgroup' if you were
currently joined by default to system.mdw. If you were joined to a secure
mdw when you ran the wizard, then there were two options - create a new one,
or modify existing (the default). If you chose to modify the existing then
you were not modifying the system.mdw.

Security.mdw C:\Documents and Settings\colm\My Documents\Databases
SYSTEM.mdw C:\cquinn ltop\program files\microsoft office\office
SBCMTMPL.mdw C:\cquinn ltop\program files\microsoft
office\office\SBT\SBCM

Open Access (no mdb need be open). Go to Tools, Security, Workgroup
Administrator. It will show you the workgroup you are currently joined to
by default. Try joining one of the other ones (likely security.mdw). Open
your database to see if you can now log in and see the owner of the objects.
If not then try joining the sbcmtmpl.mdw workgroup.

Access always uses the default mdw (as set in tools, security, workgroup
administrator). If the 'Admin' user has a password set in this workgroup,
you will get a login prompt, regardless of the database you open. When you
run the security wizard, it will create a desktop shortcut to launch your
database. This shortcut specifies a workgroup file to use (bypassing the
default one). So one normally leaves their computer joined by default to
the standard system.mdw and uses shortcuts to open secure databases. All
other sessions of Access will use the default system.mdw and get no login.

Your best option at this point, would be to determine which workgroup was
used to secure your database (as above). Then rejoin the standard
system.mdw (assuming you didn't actually modify this). Then create a
desktop shortcut to start your secure database. The target would look like:
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"

Once you are using the correct workgroup, any user you make a member of the
Admins group can 'administer' the database.

 

[Colm O'Brien]

Thanks Joan

I was joined to the wrong workgroup
I have a query regarding the shortcut to start the secure database

my database lets say is called accounts
and is in the directory "C:\Documents and Settings\Colm\My
Documents\Databases

the workgroup is securityand is in the directory "C:\Documents and
Settings\Colm\My Documents\Databases\

msaccess.exe is in the directory c:\program files\microsoft office\office11

how do i combine these in the format > "path to msaccess.exe" "path to mdb"
/wrkgrp "path to secure mdw"
colm

 

[Joan Wild]

my database lets say is called accounts
and is in the directory "C:\Documents and Settings\Colm\My
Documents\Databases

the workgroup is securityand is in the directory "C:\Documents and
Settings\Colm\My Documents\Databases\

msaccess.exe is in the directory c:\program files\microsoft
office\office11

how do i combine these in the format > "path to msaccess.exe" "path
to mdb" /wrkgrp "path to secure mdw"
colm

"c:\Program files\microsoft office\office11\msaccess.exe" "c\Documents and
Settings\Colm\My Documents\Databases\accounts.mdb" /wrkgrp "C:\Documents and
Settings\Colm\My Documents\Databases\security.mdw"

all on one line

 

[Colm O'Brien]

its ok

i found out myself by accident

thanks for all the help everyone

colm