We help IT Professionals succeed at work.

Paradox Locks - removing

SJohnson
SJohnson asked
on
Medium Priority
421 Views
Last Modified: 2010-04-04
Hi All,

Any tips on how to remove the locks Paradox puts in place when using a Table?  We have tried using a TSession component with the TQuery - no problems, but the TTable  components just wont move the locks to the private directory.

Cheers!

Stu.
Comment
Watch Question

Commented:
Hi SJohnson,

Don't think it's possible. Except of copying the table, so you've got two tables and when program closes just move the changed, new records back to one table... but this is NOT REALLY a solution.

Zif.
SJohnsonSenior Developer

Author

Commented:
Hi Ziff,

If there isnt a way of doing, how do you make Paradox multi user then?  I know this sounds really ignorant, but Im pulling my hair out!!!   We run the app on one PC, no probs, run it on another PC, and it says that the databases are locked and the program terminates.

Thanks for the info regardless.

Stuart.

Commented:
Well, I never used Paradox multi-user way... Let me look at it closer. Zif.

Commented:
Hi SJohnson,

already had a look at this article?

http://www.inprise.com/devsupport/delphi/ti_list/TI3160.html

Zif.

Commented:
SJohnson

The Database desktop is loaded on every machine i take it...you need to configure it to all point at the network file in the paradox path for instance all the machines should be mapped to the directory that contains the network file then all the paths must be set to G:\(mapped drive) this should allow multple locks of the same prog...

Later
BoRiS
SJohnsonSenior Developer

Author

Commented:
Ziff,

No, I havent had a look at it, but I will!  Thanks.

I dont really care what we use as a database, its just I thought Paradox was supposed to be multiuser :)

Thanks anyway mate.

Stu.
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
SJohnsonSenior Developer

Author

Commented:
I'll check this out ASAP.  If this works, is there anyway we can do this with a setup program that you know of?  It seems a bit harsh to expect our installers, who configure around 30 machines a day, to do this.  If there is a way, it would be great to know, otherwise, I'll just have to add it into the manual for another set of install steps.

Many thanks,

Stuart.

Commented:
One way to do this 'automatically' is to have your program set the private & working directory - instead of configuring each users machine.  On the onCreate event of the main form, use BDE calls to set the directories to the MAPPED drives.  This way, you know everyone's setup will work the same way.  This of course assumes everyone has the same mappings & drive letters on their system.

Sorry, don't have the code to set it now, but I've seen it on teh Inprise & Cobb sites.  Good Luck.
SJohnsonSenior Developer

Author

Commented:
Thanks d4jaj1.  I'll pass that on as well.  I think we can manage that by saving the paths into the registry when doing the install, and then just read it from the registry each time the app is run.

Cheers!

Stuart.
SJohnsonSenior Developer

Author

Commented:
Thanks for that, all of you.  Problem fixed and working perfectly.


Stuart.
Me too had this problem!!! Thanx for such a clear explanation. (And amusing storyline!)

Jay.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.