Hi there.
First time caller!
I have a peculiar problem and I'm stumped.
I'm writing a training database for a local charity that works in drug rehabilitation and training. For a whole load of reasons, Access is the preferred option over SQL server, so quickly reminded myself how to think Access. Since this isn't truly a professional project (for me), I've been developing it at home on my Windows 10 PC with Access 2016. There shouldn't be any permission issues, but...
I have split my Access database into a FE and BE.
It worked fine in development, but I asked a friend to test it and gave him a slightly redacted version of the BE (thinking GDPR!) and that's when the problems started; when I relinked the tables.
The linked tables are all fully accessible in the FE (and the BE) but running the following code does something really weird...
Code:
DoCmd.TransferSpreadsheet acExport, 10, "tblStudents", CurrentProject.Path & "\TCERD" & CStr(Year(Date)) & CStr(Month(Date)) & CStr(Day(Date)), True
DoCmd.TransferSpreadsheet acExport, 10, "tblCourseRecord", CurrentProject.Path & "\TCERD" & CStr(Year(Date)) & CStr(Month(Date)) & CStr(Day(Date)), True
DoCmd.TransferSpreadsheet acExport, 10, "tlkpCourse", CurrentProject.Path & "\TCERD" & CStr(Year(Date)) & CStr(Month(Date)) & CStr(Day(Date)), True
DoCmd.TransferSpreadsheet acExport, 10, "tlkpGender", CurrentProject.Path & "\TCERD" & CStr(Year(Date)) & CStr(Month(Date)) & CStr(Day(Date)), True
DoCmd.TransferSpreadsheet acExport, 10, "tblDummyStudentsMap", CurrentProject.Path & "\TCERD" & CStr(Year(Date)) & CStr(Month(Date)) & CStr(Day(Date)), True
The first two lines export perfectly but the following three throw an error - "The Microsoft Access database engine could not find the object "tlkp****". I don't get it!
I also note that trying to Compact and Repair the BE throws an error itself - "Could not use D:\********\ERD_BE.accdb; file already in use.
Lots of searches later and I give up. You all seem like nice people - any help greatly appreciated.