Any tips for securing an Access database

Hi mark

Thanks for your question

I suggest splitting the database into a backend and a frontend, using the database splitter. Each person would then access the database through their own copy of the frontend, which would only be available after they had loged on. The forms in each frontend could be tailored to the user thus allowing

1. Control over what each user can see
2. Control over what records/fields could be edited/deleted
3. Limits on what design changes can be carried out

Hope this is useful

Regards

Stephen