[AccessD] Read-Only Tables

artful at rogers.com artful at rogers.com
Thu Dec 28 13:04:50 CST 2006


I have never tried this so it's just a wag, but how about placing the tables of interest in a read/only db and then the the user queries and reports in another db that is linked to the former?

A.

----- Original Message ----
From: "Hollis, Virginia" <hollisvj at pgdp.usec.com>
To: accessD at databaseadvisors.com
Sent: Thursday, December 28, 2006 1:39:48 PM
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







More information about the AccessD mailing list