I have a db that imports some data and manipulates it and stores it in tables. When I open the DB a form show that has two buttons. On button runs the table build macros and the other button is the exit button.
I use VBA, application.quit, to close the DB. However...and there is always a however...
Upon quitting I want to open a specific spreadsheet. So I included the open code before the application.quit command.
But when the spreadsheet opens it automatically updates its information from the still open DB. So, I get errors when the spreadsheet does it's update because the DB is still open.
Is there a way I can have access not wait for the spreadsheet to open before it closes its DB? Hopefully that will be fast enough to allow the spreadsheet to update.
I use VBA, application.quit, to close the DB. However...and there is always a however...
Upon quitting I want to open a specific spreadsheet. So I included the open code before the application.quit command.
But when the spreadsheet opens it automatically updates its information from the still open DB. So, I get errors when the spreadsheet does it's update because the DB is still open.
Is there a way I can have access not wait for the spreadsheet to open before it closes its DB? Hopefully that will be fast enough to allow the spreadsheet to update.
