Timeout errror when deleting a record from SQL Server through MS Access

[Joe Contreras]

I can't delete records for a SQL Server table when I attached the table to Microsoft Access 97. I time out when I try to delete the record. However I can query the table.

I use the standard ODBC setup, do I need to do anything else beside using the standard Access link.

Thanks in advance

[Gregory]

does it happen all the time?
you can set 'Query time' value in ODBC manager for SQL Server data source.
or may be table you're trying to delete from has a trigger...?


------------
Joe Contreras at 3/11/99 9:31:30 AM

I can't delete records for a SQL Server table when I attached the table to Microsoft Access 97. I time out when I try to delete the record. However I can query the table.

I use the standard ODBC setup, do I need to do anything else beside using the standard Access link.

Thanks in advance