Issue with Concurrent Users

[stevo1961]

We have an SQL server 2000 with 20 users running Microsoft Access 2003 front-and connecting via OBDC to linked-tables on the database of the server. We have been using this set up for several years now. Just until last week everyone was able to use their Access frontend to access the data on the server. Now only one is able to use the their front-end otherwise 2 or more users using their the front-end causes their Access application stall and crash.
It seems to crash when a user tries to add or change data on a particular table on the form. We get an OBDC call fail 'insert or OBDC call fail 'update' on linked table.

We have tried re developing the FE but too no success. We decided to put a copy of last week's backup copy and this works ok, no issue all. I have ran DBCC CHECKDB and the database is not corrupted.

Could anyone maybe shed some light on what is going on here?

Thanks

 

[fredericofonseca]

looks like a windows update, or a index/table recreated with incorrect settings

rebuild all indexes on that table.

and see if the settings used to create that table and indexes are the same as the other ones e.g. set ansi nulls and so on that were in place at the time the table and indexes was created as these affect access mainly to indexes.

not sure if this is available on 2000 but if so it will help you identify what was in place when create statement was issued.

https://msdn.microsoft.com/en-us/library/ms176105(v=sql.90).aspx

and would be good if you could change your app and ensure that underlying error is displayed.

Recreating odbc connections, both in access and in control panel may help.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886