Why can't I export Access files?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jstiles5
    New Member
    • May 2010
    • 1

    Why can't I export Access files?

    Programming in MS Access, 2007 using Vista

    Attempting to export a file from current database to another database or if there isn't any database by the name chosen, I'm told, Access will create one. No matter what I do, I get some error message or other. Here is code.

    Code:
    DoCmd.TransferDatabase acExport, "Microsoft Access", _
    "C:\Users\jimLaptop\Desktop\OrganizerP(5.11).accdb", _
    acTable, "tblIncomeAndExpenses", _
    "C:\Users\jimlaptop\Documents\Test.accdb", False
    End Sub
    Error message in this case is "Could not find file C:\Users\JimLap Top\Desktop
    OrganizerP(5.11 ).accdb"
Working...