Link to open DBF file (2003)

Topic

New Reply

Is there a way to override the “exclusive” status when linking to an open DBF file from Access? I am using the following code:

DoCmd.TransferDatabase acLink, “dBASE III”, sDatabase, , sFilename & “.dbf”, sFilename

and it fails with the following error message when the file is currently opened by another program.

3051 The Microsoft Jet database engine cannot open the file ‘D:RadiumDatagpsP3.DBF’. It is already opened exclusively by another user, or you need permission to view its data.

The two programs co-exist peacefully once the link is established (both can read and write data into the same DBF file), but creating the link into Access in the first place is not working when the file is already opened.

Reply | Quote

Replies

I don’t think you can change this. According to How to use dBASE data with Access and Jet,[indent]

---

When using the dBASE ISAM to link to a table in Access, you must be able to exclusively lock the table to create the link. If any other application has the .dbf open, the attempt to create the link in Access will fail.

---

[/indent]This appears to be true regardless of whether you have installed the Borland BDE.

Reply | Quote

Thanks for the link, Hans. That clarifies what’s going on.

Reply | Quote