VB connect to Paradox

[neogeek]

Hello

I have a commercial Delphi application which resides on 4 NT workstations. This app uses several paradox (version unkown possably 6)tables through Borland Database Engine.
I have tried to link to these tables using Access 2000 but I get a message stating the table is in use by another user.
The only way I have found around this is to copy the tables to the client and remove the file "pdoxusrs.Lck".

I would like to link to and view/edit these tables using VB while the Delphi program is also in use by the other clients.

Any insight on how to do this would be greatly appreciated

TYIA

 

[Guest_imported]

I assume the table _is_ in use. Access cannot access the table in the same way as Paradox does (only locking at record level when necessary) so it attempts to lock the entire table. If there is even 1 other user with the table open, then Access cannnot connect. :-(

 

[neogeek]

Thank you for Responding OGriofa,

Since Access id out of the question. Would using VB through the BDE be an option ? if so, where could I find documentation on using VB to interface with the BDE ??
I don't recall seeing any at the inprise/borland site.

TYIA

 

[Alt255]

I believe you can use the BDE API with any Windows based programming language (including VB).


Check this site for the applicable calls:

http://www.inprise.com/devsupport/bde/bdeapiex/

​