Allowing only updates, no delete/insert

[Tawiskaron]

Hello all,

As most people have, I searched the forum and online microsoft help but was unable to find a post relevant to what I'm attempting.

I have a form with 4 text fields (Seis Survey Name, Seis Line ID, Seis Line Name, and Area Name) that allow a user to enter in a search critera, hit the search button and get their results. Using what the user enters I pass the input to a Select query. Now this query displays a number of fields from 4 joined tables (seis_line, seis_srvy, data_item and seis_line_seg).

I would like the users to be able to update some of the data being displayed, but I would like to disable record inserts and deletes.

I did disable the forms properties (Allow Deletions/Additions) to 'No', but because I pass it to query I don't think the properties are passed to the datasheet displaying the query results.

Is there a way to do this, or am I floundering? It seems so simple in theory.

A puzzled new access user.

 

[mohammadagul]

good question.. i have the same problem in confinuous form ..
any suggestions

 

[Pat Hartman]

If you want to make a query not updatable at all, you can change its RecordsetType to Snapshot instead of Dynaset. Users should NEVER be presented with raw queries because you don't have any control over them. Users should ALWAYS be given forms where you have events available to control processing and many more property settings. In a form you would set AllowAdditions to No and AllowDeletions to No.

 

[Tawiskaron]

Thanks Pat,

Makes sense if I sit back and look at it. I appreciate the help and pointers. However this won't be my last question as this is something I'm going to need to learn for work. So I'll apologize in advance for the torrent of questions that will be coming.

Regards

Wes