I have two queries which are data sources for an Excel worksheet...
My problem: If I try to refresh the Excel file when the database is OPEN, I get an error msg saying "The database has been placed in a locked state...blah blah"
[I'm running Access 02 - never had this problem in previous versions]
VBA (command button) opens the Excel file externally through Access after going through the necessary computation.
As an alternative, I could create a (new) workbook object each time through Access, but then I cannot use the graphs that I want to build and refresh in my Excel file.
Any suggestions?
My problem: If I try to refresh the Excel file when the database is OPEN, I get an error msg saying "The database has been placed in a locked state...blah blah"
[I'm running Access 02 - never had this problem in previous versions]
VBA (command button) opens the Excel file externally through Access after going through the necessary computation.
As an alternative, I could create a (new) workbook object each time through Access, but then I cannot use the graphs that I want to build and refresh in my Excel file.
Any suggestions?
