Hello,
I have an excel workbook that has numerous data connections to an Access Database. In order to update the data in excel, on workbook open, I have a code in excel that opens Access and runs action queries via an AutoExec built-in Access Macro. Using only data connections straight to Access doesn't work because I need to run those action queries to update my data at workbook open, so I have to open Access at excel workbook open. However, multiple people use this excel-connected workbook, and when someone else is already in it, the access database will open, when someone else opens the excel report and Access attempts to run the action queries which throws an error. If I didn't have to run those action queries, then I wouldn't be having this issue, and multiple people could open the excel report without error.
I'm looking to convert the AutoExec built-in Macro to VBA code, and find a way, that the AutoExec macro won't execute if the database is already opened by another user.
Does anybody have a method for this?