Questions on Update

[lwidjaya]

I have an Access 2000 front end with SQL Express 2005 back end. I need to
update one field of a table. When I update the field, I get the
"[Microsoft][SQL Native Client]Query timeout expired" error. The problem is,
it doesn't happen all the time. Sometimes it works correctly and updates the
field. But most of the time the problem happens. I've tried 3 different ways:
- ADO .update
- "Update" SQL statement
- DAO .update
All of those give me the same problem. I also tried changing the timeout
time but I still get the same problem. Can anybody help me on this? Thanks in
advance.

Lisa

 

[Alex Dybenko]

Hi,
try to update it in a link table or in sql server manger, so you get a more
meanful error message.
Also check that your table is not locked by other user (or other form/code
in your app), check triggers, if any

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Marva Powell]

Hi,
I received your message
Marva