[AccessD] Read-Only Tables

Unless you are using the new accdb format of Access 2007.

>From the article Gustav pointed to earlier at
http://msdn2.microsoft.com/en-us/library/bb203849.aspx

"As with replication, Access 2007 supports user-level security for .mdb 
databases, but not for .accdb databases"

--
Stuart

On 2 Jan 2007 at 13:44, Drew Wutka wrote:

> 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