[AccessD] Read-Only Tables

You can also do it with queries.  

Build a query.
In design view, right click the upper pane and select properties.
Click in recordset type
Select snapshot
Save the query

The query is now a snapshot, and the data can be read but not modified.


John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Tuesday, January 02, 2007 2:45 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Read-Only Tables

You can do this with Access User Level security.

Drew

-----Original Message-----
From: Hollis, Virginia [mailto:hollisvj at pgdp.usec.com]
Sent: Thursday, December 28, 2006 12:40 PM
To: accessD at databaseadvisors.com
Subject: [AccessD] Read-Only Tables


Is there a way to let users create their own reports & queries but locking
down the tables so they can't change the data? The data needs to be
read-only. If you make the database read-only, it grays out 'new' so they
can't create the queries or reports.

 

Virginia

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com