Security problem

[PaulSpell]

I need to setup security on the backend of a database. Previously I have always relied on network security as Access' own security doesn't seem very good.

Whenever I have tried this in the past and changed users permissions etc it seems to have changed their permissions and access rights for ALL of their Access sessions, even on their own databases.

Is there a way of using Access' own security to setup passwords and restrict permissions etc, but NOT affect any other Access applications users may use?

 

[wh00t]

http://support.microsoft.com/default.aspx?scid=kb;en-us;165009

here's a link to the Access security thing at Microsoft

basically u need to create a new MDW file and link your db to this, this will use the security within the MDW file instead of the standard System.MDW

the reason you have had trouble in the past is due to you putting the security on the System.mdw file, each database looks at this file for security settings, and if u changed the security for 1 database, all databases would use that security by default.