I have a database that has a search screen that allows users to type in a piece of criteria and then search for it. It displays the results on a "Results form" and allows them to scroll through as many records as is returned. It also allows them to view in datasheet format which more or less just closes the form and simply shows the results of the query in datasheet format that is hiddin behind it.
I know that if I use the following syntax:
DoCmd.OpenQuery "Query Name", , as Readonly
that it will make the data unchangeble to the end user. Is there any command that I can uses in place of the Readonly to make the data, modifiable but not deletable????
Thanks in advance
I know that if I use the following syntax:
DoCmd.OpenQuery "Query Name", , as Readonly
that it will make the data unchangeble to the end user. Is there any command that I can uses in place of the Readonly to make the data, modifiable but not deletable????
Thanks in advance