INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Issue with Concurrent Users

Issue with Concurrent Users

(OP)
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

RE: Issue with Concurrent Users

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(...

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
www.syssoft-int.com

FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close