Table Updates Failing to Execute

[markgrizzle]

Hi:
My access 2003 application uses this ado connection to sql server 2000 (I've removed line continuation characters in this example).

cnnString = "Provider = 'Microsoft.Access.OLEDB.10.0'; "
"Data Provider = 'SQLOLEDB'; "
"Data Source = 'SqlServerName'; "
"User ID = 'ApplicationUser';
"Password = 'password'; "
"Initial Catalog = 'DMAD' "

ApplicationUser is a default user that all users use to connect to the sql server.

I've assigned select, insert, update, and delete permissions to my tables for this ApplicationUser.

When I test it on the user's pc, updates fail with the following message

ODBC--update on a linked table 'TestLeg' failed.

[Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE permission denied on object 'TestLeg',database 'dmad', owner 'dbo'. (#229)

<<OK>> <<Help>>

Insert and delete operations (via the ado connection) on the same table work.
My sql tables each have a TimeStamp field.
The editing form is bound.

My hunch is that it has something to do with the system DSN I'm using, but I can't find a setting in the ODBC Data Source Administrator dialog to adjust.

Thanks in advance, any help is appreciated.

 

[jbenson001]

You'd be better off posting this in the Access forum. This is for SQL Server.

 

[SQLDenis]

Do you have a trigger on this table that does an update/insert on another table?

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[markgrizzle]

Thanks jBenson. I'll post there next. I guess my real question is; Is there anything else I need to handle on the sql server end, other than managing the user's permissions for the tables?

SQLDenis:
No triggers or stored procedures.

 

[SQLBI]

The ADP Forum (Access fe, SQL be) can be found here: forum958


Cheers,
Leigh

You're only as good as your last backup!