Drew Wutka
DWUTKA at marlow.com
Wed Jan 3 09:43:31 CST 2007
But going into the table stills allows the data to be editable. It's pretty easy to setup a data 'read only' database. Create a new .mdw. Create an account in the .mdw. Open a new database. Set Admin (User), Admins(Group), Users(group) in the new database to have the levels of access required. (ie, for only reading data, set new tables/queries to be Read Read Data and Read Design only. The Current Database should be Open/Run only) Once ALL the security settings are set to where you want them, develop the database. The database can be opened with the normal 'system' mdw, and everything will be read only. The only way to modify data is to open the database with your secured workgroup file. Drew -----Original Message----- From: JWColby [mailto:jwcolby at colbyconsulting.com] Sent: Tuesday, January 02, 2007 7:50 PM To: 'Access Developers discussion and problem solving' Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com