Only allow record additions via an access form

[smurf01]

I have created an access table and it is going to be updated via an access form, however if you open the table you can add, append and delete data. Is there a way to make the table non updatable except via the form in question. i have looked through various books on access and cannot find what i want Regards

Paul

 

[Dreamboat]

Sure, you put the table in another DB and store it on a drive that they don't have direct access to (but have write rights). Then you link the table(s) to a front end, which has only the forms....

Or you set permissions in the DB that the user group cannot VIEW the tables. Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros

 

[Storyteller]

Hello smurf01,

A low tech solution would be to change the properties of the table to "Hidden"

Right-Click on the Table select "Properties" and then click on "Hidden". This will effectively hide the table from people who don't follow this thread ;-)

To view the table do the following: "Tools" select "Options" then on the "View" tab check "Hidden"

Hope this helps,
Michael

 

[smurf01]

Thanks Dreamboat and Storyteller, i will try both and let you know how i get on Regards

Paul