Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

NT and Q&A database

Posted on 1997-03-01
1
181 Views
Last Modified: 2013-12-23
I have a problem with a old database program called Q&A (symantec). Since I transfered from Novell 3.12 to Windows NT 4.0 there are problems when 2 users write at the same time in the database. Q&A gives a write error and the database is corrupt. When this happened the index file of the database got 2 locks.

Can anyone tell me what locks are, and how I can solve this problem????????????

Evert Dieperink
evert@ted-gigaprint.nl
0
Comment
Question by:evertd
1 Comment
 
LVL 1

Accepted Solution

by:
weghorst earned 200 total points
ID: 1559472
I don't know this program, but most database program that are ment for using by more than one person at a time use record locking. This means that a part of the database (record) wil be locked. This means that only one user can access the record that is locked, and the other users can't use the same record. This is done so that it's not posible for two user to change the record at the same time.

User "A" wan't to change record "100".
User "A" tryes to lock record "100".
If the locking went ok. User "A" is able to change the record.
  At this point, it not posible for user "B" to change record "100"
If user "A" is ready with the changing, the record will be unlocked.
  At this point, it's posible for user "B" to lock and change the record.

I know that a lot of database programs that work oke when placed on a Novell file server have problem's when they are being used on a Windows NT fileserver.
I advice you to put the database back on the Novell fileserver cause you probably can't get it work on Windows NT.

You probably know Exact software (it's the most used administrative software in the Netherlands). They have the same problem with locking when you databases are put on a Windows NT server, on a Novell server it's working ok.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Greetings, Experts! First let me state that this website is top notch. I thoroughly enjoy the community that is shared here; those seeking help and those willing to sacrifice their time to help. It is fantastic. I am writing this article at th…
Are you one of those front-line IT Service Desk staff fielding calls, replying to emails, all-the-while working to resolve end-user technological nightmares? I am! That's why I have put together this brief overview of tools and techniques I use in o…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question