Keeping users away from tables

[nanfa]

Hi All,

Please is there a clever neat way to hide my tables or disallow users from accessing them directly. I have created forms with validations, and restrictions to achieve data consistency and protection. Now, if any user goes directly to my tables, they can easily mess things up. Has anyone figured out how to disallow users from messing with tables in Access? I have tried hiding my tables, and database window but anyone with some background in Access and undo this. I have tried creating an MDE file but it does not restrict use on tables. I have tried formatting the table colors from options but anyone with good Access skills can reformat the tables to read and mess up the info. There has got to be a way! Please anyone with an idea?

Thanks,

Nanfa

 

[AncientOne]

Why don't you set up user accounts with restricted permissions? It's the only sure way.

 

[nanfa]

Hi. Thanks for the reply but I'm using an Access project with SQL Server security. Adding another layer of security will require users to log into the database twice???

 

[Fizzio]

Pat has described a cunning plan here which may work for you. (last post)

 

[AncientOne]

The only other recourse you have, is to use custom menus which disable the unhide option for database window and tables. But unless you employ workgroup-level validation, a determined person will defeat other measures. They do have to be pretty knowledgeable to know all the procedures though. There aren't many like that!

 

[Fizzio]

And if they are, Sign them Up!!

 

[K_sorin78]

Help! i dont'n know what i have to do!