ODBC on linked table < > failed

[tlaksh]

I have a access 97 form linked to a SQL 7.0.database table. The form is used to delete records in the table (TABLE A)based on the date and servername the user chooses. The table in the backend has a trigger that fires on delete. The trigger has only one line..

INSERT INTO DELETEDTEMP SELECT * FROM DELETED.

Now when I try to delete data from the table A access does not allow me to deleted records and comes up with the error message "ODBC error - delete on linked table ' logrecs ' failed"

If I remove the trigger everything is fine. The trigger is very imp to further processing.

Can anyone tell me why this is happenning?? Thanks a ton

Laksh

 

[tlbroadbent]

Does the login used to do the DELETE also have INSERT permissions on DELETEDTEMP? Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes

 

[tlaksh]

Yes, I am logged in as a sa

 

[tlbroadbent]

Try this. Add SET NOCOUNT ON at the beginning of the trigger.

Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes

 

[tlaksh]

Hi Terry,

Nope...that didn't work. By the way do u know how i can Exec a SQL stored procedure in an access form. I am trying to work with out the trigger on the table. I can now insert records using DoCmd.RunSQL command, but i also need to run this code

EXEC msdb..sp_start_job @job_name = 'DTSDELETED'


Thanks a ton

Laksh