multiple users can not edit the same table, though different records

[almir]

Hi all,

We have deployed Paradox 9 on Windows 2000 machines for years. There are about 20 concurent users of the same database. Everything was fine until few days ago when users were prevented to work in edit mode simultaneously. Actually, they can turn edit mode on, but can't do anything more.

When one user is in edit mode, others can turn edit mode on, but nothing happens when they type. As soon as the first user turns edit mode off, everything typed appears on the screen. (We are suspicious about network traffic). We tried with network refresh period of 3 seconds: the same result. Previous one was 60, than 30 seconds.

we have checked BDE configuration (same with all of them): local share is off, refresh rate is 30 seconds, RIV: directory is the same folder with all users.

Corel Draw 10 was detected in the same program folder as Paradox with some of the users (not all of them), and Paradox was re-installed to a different sub-folder. This solved a problem yesterday, but today it is impossible even for two users to edit different records simultaneously.

We found this problem with all the forms within the database, so it is not the problem with just a single table.

We deleted the old PDOXUSRS.NET from the network location and it was re-created: nothing changed.

There is no rule in behaviour, so we don't know where to start from.

Any idea, please?!

 

[footpad]

Almir,

Since it was working fine until a few days ago, that suggests a couple of different possibilities:

1) A workstation somehow became configured differently than the others. This machines BDE settings may be different than the ones you're expecting. It could happen if anyone installed a BDE application (Paradox, QPro, Delphi, dBASE, etc) that overwrote the expected .CFG file.

2) A table (or an index) has become corrupted. Based on your descriptions, this counds more likely, as odd data display is frequently a symptom of table corruption. If you can trace this to a single form, try Verifying every table in that form's data model, as well as all tables opened directly in code (e.g. with TCursors).

If the tables verify fine, then it's probably an index. Manually delete and then recreate the indexes. This should take care of the problem.

Hope this helps...

-- Lance

 

[almir]

Thank you very much. However, we haven't had time to use your suggestions, since we found cause of the problem (completely different). Table header and indexes are OK. If the problem persists, we will re-index the tables and give you feedback.

Once again, thank you very much!