How can I do that?

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

Guest

I need my msaccess table in a way I cannot delete it. How can I do that?
Normally once I delete my table immediately it will delete.
 
I need my msaccess table in a way I cannot delete it. How can I do that?
Normally once I delete my table immediately it will delete.
Click to expand...

Are you talking about deleting the *table* or deleting *data from the
table*?

The best solution - if I understand your question - would be to
implement Access security on the database; give Delete privileges only
to one user account, and then don't log on with that account. You
really do NOT want to (and probably cannot) make it absolutely
impossible for anybody to ever delete from a table - but this will
make it much harder to delete from the table unintentionally.

Access security is a fairly complex and tricky area. Get a copy of the
Access2000 Security Whitepaper from Microsoft's support website, print
it out, READ IT CAREFULLY, and follow EVERY step. I have secured many
databases but I still always print a copy and use it as a checklist.

John W. Vinson[MVP]
 
Back
Top