.dbf locked !!

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

Hi

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

Ta

Kai

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

Hi, Try This

VB Code:

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

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

Hi,

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


"SELECT * FROM tablename"

Fishy

That's what I have...

Is your connection opening OK?

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

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

Thanks

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

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

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?

Yes, I have MS Access...

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

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

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

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 ?

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