Accessing Paradox Tables with VB50 1

[osoto]

Hi!
I'm trying to access paradox tables using DAO in VB 5, but when i'm trying to open a table, for example EmpPrin, VB send me the following error:
The microsoft jet database engine cannot open the file <pathfile> . It is already open exclusively by another user or you need permission to view its data.

When i create the database object in VB i open it in share mode, and the paradox tables are accessed by 2 computerers at the same time so i don't understand why vb send that error, any idea?

Thanks for your help!
osoto

 

[Guest_imported]

I'm not certain, but I think I read somewhere that VB requires a full table lock even to read a single record in a Paradox table. May be worthwhile to post question in a VB group. :-(

 

[Lionel]

I think u use bad odbc driver (microsoft driver is to access)

Try intersolv Pdx driver !

 

[osoto]

Do you know where i can get it?

i'll appreciate your help

osoto

 

[loreleifire]

For Paradox versions 3,4,5 you need to have the BDE (Borland Databse Engine) installed. Oddly, they have an Access driver which SHOULD (note- should) work with a VB app which links Paradox tables with Access functionality.

 

[lmara]

I have the same problem like osoto but with access. I have the paradox V9 tables in a novell server and I have that tables linked in access. Do you think that answer its right for me to?...
Thanks for your help...
lmara