multiple instances of same spreadsheet opening
I have an Excel spreadsheet which is the front-end of a small app, with an Access 97 backend used as a data-store (don't ask the client wanted it this way!).
I am running a query in Excel (VBA) which executes a query within the database, like so:
Dim dbs As DAO.Database
Set dbs = DAO.OpenDatabase(AccessPath & AccessFile)
...but if I have another session of Excel open and run this via a button on the spreadsheet, it causes another instance of the same spreadsheet to open.
Thks and Rgds