Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Link to open DBF file (2003)

    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.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Link to open DBF file (2003)

    I don't think you can change this. According to How to use dBASE data with Access and Jet,
    <hr>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.<hr>
    This appears to be true regardless of whether you have installed the Borland BDE.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link to open DBF file (2003)

    Thanks for the link, Hans. That clarifies what's going on.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •