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

MS Access security

P: 17
Hi Guys,

I have an access file in the network drive so people can share to open that file.
However, how do you make an ms access file more secure? Could you help me please? I want to make only autorized/certain people can open the file and only the creator of the file can delete it.
It would be great if only me can delete the file not others. Is there a way doing this?

Dec 26 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,532
If you're talking about more than one user at a time using the database, you should split it into a frontend/backend app with the backend on your network drive and each user having a copy of the frontend on their PC.

Multiple-users sharing a single, non-split database is a common cause of repeated corruption.

On the question of security, there are a number of ways, some ready-made and some custom made thru VBA code. We would need to know what version of Access you're using in order to give you the best advice on this.

As to the question of only allowing the creator of the database to delete it, you posted this question Delete Permission on 12/23/07, at which time it was answered by two different people! Re-asking the question will not change the answer and will aggravate the people who took the time to answer it for you to begin with!

Linq ;0)>
Dec 27 '07 #2

Post your reply

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