Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Project Security

Status
Not open for further replies.
TheWebDataGuy

TheWebDataGuy

MIS
Dec 5, 2001
44
US
I am developing a database solution using Access Project. My backend DB is in SQL Server.

I have questions about securing the DB. I would like to hide all the tables when the user open the DB using Access Project, so that they donot make any design changes. So in the object explorer window I want to display everything except the Tables. But I want users to be able to SELECT, UPDATE, INSERT and DELETE records from the database using Forms. The again I don not want to them to delete the whole bu running a delete query by mistake.

Sounds like complicated permissions.

Is this possible?

Thanks!
 
Status
Not open for further replies.

Similar threads

Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
404
Xavierparkash
Xavierparkash
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
2K
JanaLNelson
JanaLNelson
TheresAlwaysAWay
  • Locked
  • Question
"There isn't enough memory to perform this operation..." error after upgrading from Access
Replies
2
Views
428
Axworthy
Axworthy
leifoet
  • Locked
  • Question
How to store decimal numbers in an Access database?
2
Replies
27
Views
2K
Andrzejek
Andrzejek
priac
  • Locked
  • Question
Create a Duplicate of an Existing Record in Microsoft Access but leave some fields blank.
Replies
7
Views
1K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top