Discussion Locked

File/Record not locking when opened

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

For some reason, whenever database files (or any file for that matter) is opened by a user it is not locked. This is problamatic with databases, since two or more users can make changes to a specific database at the same time. I would like to knowif there is a method to ensure that opened files will automatically lock, and if possible be a method that is not dependent on the client software.

Thanks,

David Stevens

7 replies

by mtnsqs

With databases you should not be file locking - that would mean only one user could access the entire Db at a time! The database system itself handles multiple access and multiple users (Access does not do this correctly at times, but any reasonable Db will) This allows many users at once - most will only be reading at any time, and the DB will appropriatly lock the table or record for update (some Db's lock the table, others will record lock or part table lock).

by dragon_45

I do not know what database you are using.
In Dataease you can tell it to lock files or records, or share files or records Etc. Check your settings in the database. Set them according to your needs. You can also lock your database during certain functions, just remember to unlock it because no one else will be able to get in. Novell also applies file and record locks by itself. I have minimum locking from our our database.
Novell allows it to share records. If someone
is updating a particular record it would modify the record then change when they reaccess the record. You can test this on your system. Try sitting on a record while someone else then modifies it. Then reaccess the record. You can try this on a test database so your active Db will not be corrupted. When you get your desired results, apply the changes to your active DB.
Good Luck
Richard Bolha
Dragon@one.net

by estebandelatorre

Netware 4.11?
You will need to apply sp7a for Netware.
It?s a very short-easy to install sp wich loads a pair of nlm in the startup.ncf file.
You will need to restart the server.
The explanation is that the file could be opened by many threads at the same time. Sometimes, when you close the file - such as a .doc file - it remains open.
If you need it, I could send it.

This discussion is closed to new replies.