ADO problem accessing dBASE tables 
Author Message
 ADO problem accessing dBASE tables

Hi,

I have a program that has to access several dBASE tables that are stored in
a server (I know that dBASE isn't the right database for such cases, but it
was not me that developed that system...), and that is my situation: I'm
using ADO 2.5 and in my computer it works fine; I can access all tables all
the time. The problem is that in some computers (not all), it sometimes work
sometimes not... In those computers that I have problems, when the program
tries to access some tables (not all) something like this appears: "The
Microsoft Jet database engine could not open the table MYTABLE because it is
already open in exclusive mode by another user..";
What I can't understand is that it works on some computers and doesn't work
on others.. The problem isn't the operating system because  my is Windows NT
4 and it works Ok, but there are other windows nt's where it gives problems.
Do someone has a clue that can help me, please?

Thanks,

Tiago Gehring



Fri, 20 Dec 2002 03:00:00 GMT  
 ADO problem accessing dBASE tables
[This followup was posted to microsoft.public.vc.database and a copy was
sent to the cited author.]


Quote:

> I have a program that has to access several dBASE tables that are stored in
> a server (I know that dBASE isn't the right database for such cases, but it
> was not me that developed that system...), and that is my situation: I'm
> using ADO 2.5 and in my computer it works fine; I can access all tables all
> the time. The problem is that in some computers (not all), it sometimes work
> sometimes not... In those computers that I have problems, when the program
> tries to access some tables (not all) something like this appears: "The
> Microsoft Jet database engine could not open the table MYTABLE because it is
> already open in exclusive mode by another user..";
> What I can't understand is that it works on some computers and doesn't work
> on others.. The problem isn't the operating system because  my is Windows NT
> 4 and it works Ok, but there are other windows nt's where it gives problems.

I don't know why, but it works with all NT4 and Win98 machines running
the BDE (Borland Database Engine). My Delphi programs are not using any
BDE calls (ADO only) and I'm not amused to have to install a BDE in order
to get a shared xBase access with ADO. But this is the only way I found.
I would be glad to get to know a real solution too.

chiao
Heiko Rebhan

--



Tue, 07 Jan 2003 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Accessing Paradox or dBase tables from C++ HELP!

2. Accessing Dbase Tables (*.dbf) through DAO

3. DAO Seek on dBase Tables with NULL fields: Problem

4. Need help adding to table via ADO.NET (MS Access database)

5. Problems with Accessing Dbase Files through ODBC

6. ADO & Multiple database table Problem

7. How to use dBASE IV (Fox Pro) tables ?

8. Creating dBase-tables using DAO

9. want to add field to dbase table

10. How to send a CRecordSet the path to open a dbase III table

11. ODBC - dBase table exclusively locked...(IE5?)

12. dBase ADO & C#

 

 
Powered by phpBB® Forum Software