Deleting a database

[cer5yc]

I have a database that is stored on a shared drive. I don't want anyone to be able to delete the database. Is there a way to do this? Thanks!

 

[genomon]

Talk to your network people and have them assign limited rights to your users.

When everything is coming your way, you're in the wrong lane.

 

[cer5yc]

Well that's what I figured the answer would be - but it sure wasn't the answer I was looking for

 

[jrbarnett]

Thing is, because to the operating system, an Access database is just a file on disk, it can be got to with any of the usual file access tools.

Cer5yc's answer is the only way to doing it, unless you want to move your application code to a locked down server and data into a server side database engine.

John

 

[chiefvj]

I have been agonizing about the same problem. Our IT manager says to give the user read only access. However, the user will not be able to delete. add or update records. So there is no way to prevent someone from deleteing your database.
"sad

 

[missinglinq]

What's really sad is that an "IT manager" doesn't understand that the "users" of a database can't "use" the database if they can't add/edit/delete data!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[jrbarnett]

Could you not put the data in SQL Server Express or MySQL, then link the tables through from Access with an account that has appropriate rights to do the data manipulation.

You then have a read only front end, but permissions to be able to manipulate data on the back end store.

John