Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Linking table to external text file

    I'm trying to link or import a file wiht "dbf" extension "dBaseIII(*.dbf)".
    Access throws :
    "The Microsoft database engine couldn't fing the object 'Addresses.dbf'."
    I know that Access has no problem with reading "dbf" files.
    Can you help me please .


  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    Is this a one off link (ie you are importing the data into an Access db, and then ignoring the dbf), or a permanent link (ie the dbf retains information)

    How have you specified the path to the dbase file. Even when I'm developing on a single PC I tend to fully qualify the location of any external resource with the URL

    I'm not sure how access will resolve the filename to a physical location. Presumably it depends on what you have set your start up directory to be (either in the shortcut or tools | settings)

    So I'd suggest you need to identify where the file is and explcitly tell access at the time of linking where it is.
    \\<servername>\<path to object>
    so presumably in this case it could be
    \\geriatricserver\godknowswhere\dbasefiles\data\ad dresses.dbf

Posting Permissions

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