I have a SQL database that the users have Read/Write access via AD and a VB application. I want to set up an ADP project for reports and inquiry selections.

When I set up an ADP it shows all the tables and views etc. I want to restrict them from modifying data in the ADP. I can make it to where they can't modify the structure or add new views etc, but it still allows database manipulation.

Is there some way that I can set the data as read only?

David

If this is a true OLAP database, then don't connect it to SQL. Just import all the table data when they open the database, and let them do what they want with it. Anyway, that is what I would do.

An alternative is to create a Read Only account on SQL server, and set its authentication to Mixed. Then pass the credentials in plain text (since it is read only) in your connection strings. Then when they open the database, it logs in automatically as though it were using AD/Windows NT authentication, but they have read only.

Another solution is to change their rights on the single database to read only. Just create a group called Readers, and put all of your readers in it. This will take the longest, but is the tightest.

HTH

mmcdonal

Thanks mmcdonal. the Mixed Mode would be best I think at this point. the thig is that the do need write access, but only via the VB program, this front end will only be used for reporting and inquiries, so setting them all read only wouldn't be valid.

Thanks again!
David