By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,294 Members | 2,517 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,294 IT Pros & Developers. It's quick & easy.

Record-Level Security

P: 2
Hi,

I need to set security at the record level of tables and queries. I need to allow some users access to all records in a table but I need to restrict the access of records within that same table for other users. I can't make two different tables. Any ideas how to restrict access to specific records?

JC
Aug 28 '06 #1
Share this Question
Share on Google+
2 Replies


PEB
Expert 100+
P: 1,418
PEB
Hi,
I have one! Instead to use the table for showing and modifying your data, you can do it using queries.

1. You can Save the tables with your information in a separate database with startup form and no permission to see the database window

2. You can do an other database where to attach tables, you can do also startup menu without access to the database window and from this startup menu you can open queries that visualize your information.

3. You can create read only query for an user and editable query for an other

4. Also you can lock certain fields of a query for one user and you can permit edition for ana other

I hope that this'll be usable

Have a nice day!
Aug 29 '06 #2

P: 2
Sounds like it should work. Thanks!

Hi,
I have one! Instead to use the table for showing and modifying your data, you can do it using queries.

1. You can Save the tables with your information in a separate database with startup form and no permission to see the database window

2. You can do an other database where to attach tables, you can do also startup menu without access to the database window and from this startup menu you can open queries that visualize your information.

3. You can create read only query for an user and editable query for an other

4. Also you can lock certain fields of a query for one user and you can permit edition for ana other

I hope that this'll be usable

Have a nice day!
Aug 29 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.