.dbf locked !!

[sebs]

Damm thing!

I want to open a .dbf db and do a SELECT, I am using ADO

It works when no one is using the .dbf, but it wont be the case, so I get this error:
Could not lock table 'tablename'; currently in use by user...

Here's my connection string:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & bookManagerPath & ";Extended Properties=DBASE IV;Mode=Read;"

[kaihirst]

Hi

youll have to specify the max connections as in Dbase 4 it defaults to 1..

Ta

Kai

[sebs]

Specify it from VB ?

The thing is my client has a store inventory program that use those DBFs database all the time and I am making a program that is reading that database and updating his online database for e-commerce.

I could always make a copy of it, but the file is like 18MB and it will take an extra 2-3 minutes evertime.

There must be a way to open it without trying to lock it ??

Thanks

[Fishy]

Hi, Try This

myConn.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Extended Properties=Driver={Microsoft dBase VFP Driver (*.dbf)};UID=;SourceDB=c:\DATA;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"

[sebs]

Hmm, now it tells me that my table does not exist...

How would I do a select ?

I tried:

FROM tablename
FROM tablename.dbf
FROM [tablename#DBF]

All with the same results...

[Fishy]

Hi,

In your path for your connection just point to the DBF folder


"SELECT * FROM tablename"

Fishy

[sebs]

That's what I have...

[Fishy]

Is your connection opening OK?

[sebs]

Oops, I didn't put my path from the code you gave me

It's works if it's not open, but it still does not let me if the database is opened.

Thanks

[Fishy]

Hi,
Try connecting with ADODC (shudder) control. If you can then we can look further

[sebs]

Sorry Fishy, not too familiar with ADODC, is it in the components ?

Also, just a note, I tried with DAO and it gave me a different error, "Open exclusively by another user", I guess that is the real issue and I don't think there's anything to do ? I can't even copy the file !!

[Fishy]

Hi,
Yes it's looks that way. We use VFP on one of our systems and I can Interrogate the DBF's no problem with VB6 & ADO. Just a note do you have Ms Access?

[sebs]

Yes, I have MS Access...

[Fishy]

Try Linking to the DBF table it might be worth a try..

[sebs]

Damm, good thinking, I linked it and opened it but then I close it and open the DBF and went back to Access and open the linked table and I get the same error I get it VB !!

Thanks for you help, I guess there's not much I can do

[Fishy]

Pity.. Is there any way you can ask the original developers about taking the locks off?

[sebs]

Hmm, the program is an old dos Book Manager, I don't think that we can ask for a change.

I will have to tell my client to run a backup and run my program on the backup file.

Why the engin is trying to lock the database, it's a DBase way of doing it ?

[Fishy]

Tell them they really need an upgrade and a re-write in vb6. lol