Access Security features

[chris990]

I see Access has security features, such as creating group accounts with varying levels of permissions....This all works great for my computer, as I want an administrator and read-only user accounts. The problem is that these setting seem only to apply to my machine and are not present when the database is accessed from another terminal. Is there any way to attach these security measures to the database itself as opposed to just the local settings on my machine? Thanks.

 

[ScottGem]

You should create an mdw file with the apps name and distribute that to other PCs.

 

[ghudson]

Sounds like you modified the default System.mdw file on your computer or your computer is joined to a new security .mdw file.

Search the forum for the key words SECURITY and SYSTEM.MDW for there are thousands of postings covering the topic. Access security is huge and you can not learn it all from just reading one posting.

 

[chris990]

forgive me, but you can save me a lot of time. How do you create a .mdw file and apply it to the database?

 

[ScottGem]

make a copy of system.mdw in the same folder with the app mdb and name it the same as the mdb.

 

[chris990]

works on my machine, but it didn't work on another machine? am I missing something?