
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
--