Lock table additions for Demo version of database.

[JayF]

Hi all,

I have built an Access 2007 database for somebody and now have some other people interested in it. I currently have it full of dummy data and would like to limit the tables so that no further records can be added. They would ideally still be able to edit the data in forms and datasheets, just not add any new records. This is so I can email out a demo version for them to try out.

I've not been able to find much on this on Google, is it even possible?

Thanks in advance.

[NeoPa]

It depends so much on various details you haven't included in the question, but a basic shot would be to handle the Form_BeforeUpda te() events for all your forms and include code that sets Cancel = True.