Re: Hlp - DB security mystery

What version of Access on your computer? On their computer? Has there ever been any other versions of Access on either computer?

As Keith says, you can secure it manually; read the security FAQ and you can follow the manual steps outlined on the 97/2000 page at my website. If you've studied the FAQ/whitepaper/etc, then the steps should make sense to you.

--
Joan Wild
Microsoft Access MVP
"dee" <dee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:04509EC9-58E1-456A-B496-825EBFF13641@xxxxxxxxxxxxxxxx
Hi,

I have successfully secured a number of databases - practised on many in
order to gain a good understanding of security and then enforced security on
my database.

I followed Joan Wild's instructions and successfully secured the db - when I
finished, I set the system.mdw back, went to Windows Explorer and tried to
open the db and got the message saying I didn't have access. Used the
shortcut on the desktop and was prompted for user name and password. All was
working very well.

The db will have data entered by a few users, so went to one of their
computers, logged on as a data entry user, and tested opening from Windows
Explorer - no problem. I triple checked the mdw and the Users group has NO
access, the Admin user only has access to the Users group and my users are
part of a DatabaseEntry group which has non-admin rights (I am the only user
with Admin permissions) but access to forms, queries, etc. in order to input
data.

I then logged on as administrator, unsecured the db by granting User group
all permission, making sure to join the system.mdw and then creating a new db
and importing my tables, forms, queries... Then followed all of the steps
to secure, including creating a brand new mdw. At the end of running the
user level security wizard, it says the db is secure, the snapshot indicates
it is secure, everything looks fine. But, again - I can just double-click
the file and open it in Windows Explorer.

The database in on a network share to which only my group and I have access.

Is it possible that it's something that the network people did when setting
up the share?

If anyone has encountered this problem, I would really appreciate any advice
or ideas. I am totally stumped.

Thanks!
--
Thanks!

Dee
.

Relevant Pages

  • Re: Security not clicking
    ... looked good until I copied the secured database to the network. ... Joan Wild wrote: ... When I rejoin the system mdw, ... split the database when it is secure or when it is not secure? ...
    (microsoft.public.access.security)
  • Re: Hlp - DB security mystery
    ... One of the other computers has as well, ... I triple checked the mdw and the Users group has NO ... to secure, including creating a brand new mdw. ... The database in on a network share to which only my group and I have access. ...
    (microsoft.public.access.security)
  • Re: Join a Workgroup
    ... shortcut in order to open your secure database. ... the Users Group, you can't change that. ... I now am try to split my database by using the instructions you provided ...
    (microsoft.public.access.security)
  • Re: User Level Security allowing External Queries
    ... In order for it to work,you can give the Users Group open permission on the ... database object, and read data permissions on the table. ... "Joan Wild" wrote: ...
    (microsoft.public.access.security)
  • Re: Able to open secured database with default MDW
    ... System.mdw then double-clicked the "secured" database. ... "Joan Wild" wrote: ... Susan L wrote: ... Are you sure you were joined to your secure mdw when you added the ...
    (microsoft.public.access.security)