-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Security/multi user
- Thread starter gdspeare
- Start date
SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
Access security is a pretty big topic. Possibly the best generally available solution is to use Workgroup Security. It's not simple to understand all the wrinkles, but a guy called Garry Robinson has recently published a book on Access Protection and Security. There's a good review of it on this site: go to article 120 and download. I have just purchased the book and am starting to work my way through it.
Couple of things to think about:
1. Split the database and put the back end on the server drive. Place it in a folder with restricted access, so only those who need to use the database can get to it.
2. Distribute the front end as an MDE; that way, all of the database logic (queries, forms, reports, code) is safe from change. Just mkae sure you keep a full MDB version for development...
Denis
Couple of things to think about:
1. Split the database and put the back end on the server drive. Place it in a folder with restricted access, so only those who need to use the database can get to it.
2. Distribute the front end as an MDE; that way, all of the database logic (queries, forms, reports, code) is safe from change. Just mkae sure you keep a full MDB version for development...
Denis
Upvote
0
Similar threads
- Question
