SQL Server 2000 Security Privelage for MS Access

[mitchellr]

Hello,

I have recently designed some Microsoft Access Forms which can be used by users to manipulate data in an SQL 2000 database.

The forms are linked to the SQL tables.

The problem I am having is in one environment the forms are able to access the data and manipulate data within the SQL database. However in another environment (which will be the production environment)the forms read the data fine but can not alter the details on the database.

I have checked through the security permissions and could not see anything that stuck out to me, but would not call myself an expert on this issue

Any suggestions??

Thanks

Mitch

 

[jschaddock]

Do your users only have read-only access to the production database? Do they have update permissions on the required tables/views?