Solved

Paradox Table in a directory under Windows NT

Posted on 1998-12-01
7
171 Views
Last Modified: 2010-04-04
Hi

Under Windows NT, I have created a paradox table in a directory, and created several indexes as well.

What i have found is that whenever indexes are created, NT lockes the folder and does not allow you to Rename or Delete the folder.

How do i overcome this? I want the databases and index files to stay in the folder and be able to rename the folder. does this problem have anything to do with Opportunist Locking (which i am not familiar with) under NT?

Regards
Keith
0
Comment
Question by:keithcsl
[X]
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
7 Comments
 
LVL 1

Author Comment

by:keithcsl
ID: 1348829
Edited text of question
0
 
LVL 3

Expert Comment

by:williams2
ID: 1348830
I'm not sure if you are right! What I think is, that you forgot to free the dbase-connection before leaving the application. The table should be closed when you exit, so that NT would know, that nobody is using the table.
Creating a primary index is only important to the table, but creating a secondary index (known as foreign keys) may depend upon other tables.

Opportunist Locking leaves a table-entry unlocked when reading but not when writing.

Pessimistic locking locks a tabel-entry BOTH when reading and writing.

pessimistic locking is mostly used with distributed services, where time becomes essential and where severel users may have interest in the same entry simultanously.

Locking is to prevent multiple users of a tableentry to write to the same datafield simultanously. This is of special importance to calculated fields.
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 1348831
hi keithcsl,

this is the method from NT. The Folder is in use. Try to open a Winworddocument in a NT Folder, while you have open the document you cannot rename or delete this folder where the document resist.

meikl
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Expert Comment

by:Romanian
ID: 1348832
Look in BDE Administrator Configuration Page and set Property
System\Init\LOCAL SHARE = True
If that comment doesn't help you, send code which create this tables and indices.
0
 
LVL 1

Author Comment

by:keithcsl
ID: 1348833
kretzschmar

i think you are right, NT keeps track of what files the application  is using. if an application references a file, for example, setting the TableName of a table will (i think) tell NT that the table is in use (even after the active property is set to false).

so, i have resorted to not having to rename the folder. initially i was using renaming of folders as a way of locking the directory, which i think is dumb. i am using file lockings now....

thank you all for bearing with my stupid question....

Regards
Keith
0
 
LVL 27

Accepted Solution

by:
kretzschmar earned 50 total points
ID: 1348834
hi keithcsl,

will you give me the points?

meikl
0
 
LVL 1

Author Comment

by:keithcsl
ID: 1348835

sure, i think you have helped me verify that NT keeps track of an application's file usage more carefully than WIN95

ta

Keith
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

730 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