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