GenePester
Programmer
I am trying to import reports and macros from an Update.mdb to my current.mdb. I am using the following:
DoCmd.TransferDatabase acImport, "Microsoft Access", App.Path & "\" & "BA_Update.mdb", acReport, strNewReportInfo(n, 2), strNewReportInfo(n, 2) & "_NEW".
When I run this I get an error in the destination mdb that "MS access can't save the design changes ... because an other user has the file open. To save your changes .... You must have exclusive access.
Thing is I can import Tables and Queries without any problem. I just can't import Reports and Macros. I am the only one using the two databases. They are both on my machine, no external users.
Any Ideas? I am pulling my hair out. Thanks!!"
DoCmd.TransferDatabase acImport, "Microsoft Access", App.Path & "\" & "BA_Update.mdb", acReport, strNewReportInfo(n, 2), strNewReportInfo(n, 2) & "_NEW".
When I run this I get an error in the destination mdb that "MS access can't save the design changes ... because an other user has the file open. To save your changes .... You must have exclusive access.
Thing is I can import Tables and Queries without any problem. I just can't import Reports and Macros. I am the only one using the two databases. They are both on my machine, no external users.
Any Ideas? I am pulling my hair out. Thanks!!"