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

Protect a row from being deleted

P: n/a
Rob
Is it possible to prevent a row from being deleted in a table. I want
to arrange a new table with an autonumbered primary key that will form
part of a set of sequential serial numbers. I want to protect the
integrity of the sequence so that an accidental deletion of a row can
not occur.

With thanks
Rob
Sep 29 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Rob" <dy@woodyallan.bizwrote in message
news:MH*****************@news-server.bigpond.net.au...
Is it possible to prevent a row from being deleted in a table. I want to
arrange a new table with an autonumbered primary key that will form part
of a set of sequential serial numbers. I want to protect the integrity of
the sequence so that an accidental deletion of a row can not occur.

With thanks
Rob
Set the "allow deletions" property of the form to "no" and provide a field
to flag records as deleted then filter accordingly. Also, don't rely on
AutoNumber for sequential numbers, provide your own using the DMax function.

Keith.
www.keithwilby.com

Sep 29 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.