Is there a way to limit a table allowing updates but not adding new records in? Ideally we would like to throw an error when a new record (item) is scanned into the database. I have been searching for two days and about ready to lose my mind!
You can do a great deal with forms, including setting AllowAdditons to false. Other options are AllowDeletions and AllowEdits. You will find these properties on the form's property sheet (design view).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.