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.
Error message in this case is "Could not find file C:\Users\JimLap Top\Desktop
OrganizerP(5.11 ).accdb"
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
OrganizerP(5.11 ).accdb"