R RobFMS Mar 15, 2004 #2 If you are using the DoCmd.OpenQuery, there is a parameter (not sure which one it is) that allows you to display it as Read-Only. -- Rob FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
If you are using the DoCmd.OpenQuery, there is a parameter (not sure which one it is) that allows you to display it as Read-Only. -- Rob FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
J John Vinson Mar 15, 2004 #3 Is there a way to make the results of a query read-only? Click to expand... One simple way is to make it a Totals query, grouping by all the fields.
Is there a way to make the results of a query read-only? Click to expand... One simple way is to make it a Totals query, grouping by all the fields.
R Rick Brandt Mar 15, 2004 #4 JC said: Is there a way to make the results of a query read-only? Click to expand... Set the RecordSetType to"Snapshot". It's one of the properties in the property sheet while in design view.
JC said: Is there a way to make the results of a query read-only? Click to expand... Set the RecordSetType to"Snapshot". It's one of the properties in the property sheet while in design view.
