Re: Limiting access with Access

From: Michael M <~okana_at_msn.com>
Date: Tue, 8 Jun 1999 09:17:53 -0700
Message-ID: <rqb73.78$9L.15910@news3.usenetserver.com>

I don't believe they can modify the tables in Access - only the table data.

If the data is a problem - then assign IDs with roles that limit their access to read only.

Mike

BPowell601 <bpowell601_at_aol.com> wrote in message news:19990608003235.24057.00001559_at_ng-fq1.aol.com...
> We have a database that requires some tables to be modifiable by public.
this
> is so a piece of software can make required modifications. We lock the
users
> out by inserting rows in product_profile. This works well for SQL*Plus.
>
> We recently hired a group that accesses the DB using Access. they have
> unlimited modification ablitiy to these tables. Is there anyway to block
> this??
Received on Tue Jun 08 1999 - 11:17:53 CDT