Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    6

    Unanswered: TransferDatabase help

    Hello everyone,

    I have an access database ("Inspectors") that I would like to export to .dbf ("Inspectors.dbf") using the TransferDatabase action. The main table I want to transfer is called "SFTable".

    I am using the following code:

    DoCmd.TransferDatabase acExport, "dBase IV", "C:\Inspectors.mdb", acReport, "SFTable", "Inspectors.dbf"

    When I run the code, a message box appears saying that "C:\inspectors.mdb" is not a valid link. The database is there and it is not corrupted. Am I coding it wrong?

    Thanks for your help.

  2. #2
    Join Date
    Nov 2003
    Posts
    267
    If "SFTable" a tabel or report. The code you entered says it is a report. If it is a table that could be what is cuasing your problem.

    S-

  3. #3
    Join Date
    Nov 2003
    Posts
    6
    It's a table. I tried changing the code to acTable instead of acReport and I got the same error. It reads:

    Run-time error '3044'
    "C:\Inspectors.mdb is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides."

    Any ideas what this is all about?

    Thanks for the help!

Posting Permissions

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