G
Guest
I have a database which has security applied to it. Is there anyway that I
can make a working copy of it?
can make a working copy of it?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
Not sure what you mean by "working copy" , but to copy a database with
security, just copy the MDB file and also the needed MDW file. Make sure
you build a shortcut that points access to that appropriate mdw file, or
join that workgroup before trying to open the file.
security, just copy the MDB file and also the needed MDW file. Make sure
you build a shortcut that points access to that appropriate mdw file, or
join that workgroup before trying to open the file.
G
Guest
There is, however, other things that come into play. I recently built a 2002
DB with user level security. When I took the DB home (on a flash drive) and
put on my hard drive, it opened right up. No MDW file, just the MDB file. I'm
currently trying to figure out how to get it back to where you need all the
files to get it to work.
DB with user level security. When I took the DB home (on a flash drive) and
put on my hard drive, it opened right up. No MDW file, just the MDB file. I'm
currently trying to figure out how to get it back to where you need all the
files to get it to work.
R
Rick Brandt
Jim said:There is, however, other things that come into play. I recently built
a 2002 DB with user level security. When I took the DB home (on a
flash drive) and put on my hard drive, it opened right up. No MDW
file, just the MDB file. I'm currently trying to figure out how to
get it back to where you need all the files to get it to work.
Then it was never secured properly to begin with. I believe that a high
percentage of Access files that people "think" are secured are in fact not
because they don't perform the most basic of tests which is to see if it can be
opened without the proper MDW as you did.
Most likely you left "Admin" as the owner of the database. Owners have rights
even when all of their "permissions" are taken away.
G
Guest
At first, you are correct. Since then, I changed all ownership to myself (I
never use the admin to sign in). Now, when taking it to another machine, when
the DB is opened, the ownership of all the objects, including the DB, is
"<unknown>". It still openes. Does this indicate that I need to remove Admin
from the users group or it's permissions?
jim
never use the admin to sign in). Now, when taking it to another machine, when
the DB is opened, the ownership of all the objects, including the DB, is
"<unknown>". It still openes. Does this indicate that I need to remove Admin
from the users group or it's permissions?
jim
R
Rick Brandt
You cannot remove admin from the users group, but yes the users groups shouldJim said:At first, you are correct. Since then, I changed all ownership to
myself (I never use the admin to sign in). Now, when taking it to
another machine, when the DB is opened, the ownership of all the
objects, including the DB, is "<unknown>". It still openes. Does this
indicate that I need to remove Admin from the users group or it's
permissions?
have zero permissions since the users group is identical in ALL mdw files.