Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Preventing the query result from editing

Status
Not open for further replies.

rukk

Programmer
Dec 29, 2003
38
US

I have a table from which i want to show some feilds as query result. It is just a simple query.

select No, ID, Name from tbl;

But when i do this the resultant records can be edited by user, but i don't want the user to edit it. Is it possible to do that?
 
I got the answer too.
We can set the Recordset type property of the Query to Snapshot then it won't allow the user to edit it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top