|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Preventing linked tablesWell, I thought I had my security pretty well set. I had everything
unchecked in startup, limited users accounts and disabled the shift key. However, after I left on Friday, someone apparently needed to look at my tables, because they did something I had not thought of; they created a new DB and linked to my tables. By doing so, they no longer are bound by the securities I had in place and can modify my data at will. Is there any way to prevent this?? Deny access to your tables for all users (except yourself) and use RWOP
queries with appropriate permissions set. It also sounds as if you need to remove permissions as appropriate to the "database" object. HTH - Keith. www.keithwilby.com Show quoteHide quote "Bryan" <Br***@discussions.microsoft.com> wrote in message news:D97C8831-DBDB-4B3D-B2F8-CE5F1BA7F48E@microsoft.com... > Well, I thought I had my security pretty well set. I had everything > unchecked in startup, limited users accounts and disabled the shift key. > However, after I left on Friday, someone apparently needed to look at my > tables, because they did something I had not thought of; they created a > new > DB and linked to my tables. By doing so, they no longer are bound by the > securities I had in place and can modify my data at will. Is there any > way > to prevent this?? If you have not followed an explicit list of written instructions -
adding and omitting nothing - then your database is almost certainly *in*secure in one or more ways! Did you follow a list of instructions? HTH, TC 
Other interesting topics
Report of database object permissions
Security file not holding changes Some users have to rejoin workgroup daily, why? macro security error message how to secure a new db with an existing .mdw Removing Security DB Splitter err Assign a workgroup to a workspace object - Thanks to Paul Overway Opening MDB with and a workgroup file. RWOP Not Working |
|||||||||||||||||||||||
