"Update" request

[Leo Koach]

I wrote a program that uses one Access database in a server runs win 98 and multi user accessing this database constantly. There are more than ten users accessing and making changes in the database all day. Here is my question:
Before update the cashed recordset into the database how can I check the table is in use or not at that moment and if it is in use at that moment how can I reply my update request with a little loop.
As far as I know “update” locks the selected row or table automatically (Default) till its done. But it seems like multi users crashing the database tables somehow.
I use Wind 98 2nd addition and ADO. My client uses Win 98 as well.

Any help appreciated.

Thanks.
Leo Koach

www.openplace.com

[Leo Koach]

I think I found the answer.

I was reading the Access 2000 book and there it is telling me that access database client-server mode is not reliable at all.

But there is another thing that I can use to minimize the crashes. Error traps. With an error trap ADO connection tells me that table is busy. Well actually I knew that part but I just didn't know how to go around it try it till it gets free.

I will have more research on this subject. If anybody has anything to say about this please do so. I need as much as I can get to learn better.

Thanks
Leo

www.openplace.com