Read only view

R

Rena

Hi all,
Are there any way to make a read only view on MSAccess? Could you guys
should me the steps?

Thanks a lot.
Rena.
 
J

Jim Bunton

You could use the Security system, Create the query you want then remove the
insert, update and delete priviledges for users other than Admin

You could use a form with allow edits, additions & deletions set to No

In code you can open a recordset with dbOpenSnapshot in the create recordset
statement
 
Top