June Macleod wrote:
> I have an msde database (SQL Server 2000) with an web front end. I
> would like to create an MS Access Project to allow certain users to
> create ad hoc reports.
>
> I have created a new login named Reporter and connected to the msde
> database using this user. This user has dbreadonly permissions.
>
> This works to a certain extent in that new reports can be created
> based on existing tables. However, I would like the user to be able
> to create their own select queries and cannot find a way to manage
> this. I recieve a message saying the user needs 'Create Procedure'
> rights.
>
> Can anyone tell me how I can let Reporter create their own queries
> but not add/edit/delete any existing data?
>
> Many thanks
>
> June