File/Record Locking in dBase IV DBs 
Author Message
 File/Record Locking in dBase IV DBs

I am accessing a dBase 4 table through VB6:

Set WkSpace = DBEngine.Workspaces(0)
Set dbPhoto = WkSpace.OpenDatabase(strDBPath, False, False, "dbase iv;")

Q: How do I lock the whole table, and how do a lock an individual record...

I currently use the following code to generate the recordsets:

strSQLSearch = "Select * from " & gstrTableName & " where FILENAME = '" & _
                                gtypPhoto(gintIndex).strOldPhoto & "'"
Set rsSearch = dbPhoto.OpenRecordset(strSQLSearch)

I've tried using the OpenRecordset Options and LockEdits arguments but I get
a 3001 error: "Invalid Argument..."

Can anyone point me in the right direction?

Thanks in advance

Sat, 11 May 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. How can I read record from dBase IV (.DBF) with VB 6

2. Can Ojects be stored in DBASE IV Record

3. Delete records when using dBase IV

4. Deleting records in dBase IV

5. Update Record in DBase IV ???

6. dBASE IV Files <> BSIC

7. Open a dBase IV file

8. Reading fields from a dbase IV file

9. How to delete a recordset of dBASE IV DBF file use VB4

10. dBASE III/IV & FoxPro Index files

11. Accessing the memo field of a DBase IV file

12. Crystal Reports choking on dBASE IV files


Powered by phpBB® Forum Software