Preventing users from changing basic structure/design of a databas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that other users share, I need to know how to prevent them
from changing/editing the basic structure/design of the database. Any
suggestions would be appreciated.
 
Make it an MDE file and/or use User level security.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Building a database with multiple linked tables from other databas 2
Preventing users from changing the structure of a Access Database 4
Lock the navigation pane 0
Making changres to the design and code 2
Database Locking when going to form design view 4
ACCESS 2003 SP3: "The database has been placed in a state by user 4
How to Migrate IMAP Email to Office 365 Easily 0
Prevent Duplicate Form Entries 0

Back
Top