I am using Access 2007, and have inherited a database from another person, who has left our company.
When the Main Menu is loaded a macro is run that opens a table, deletes its contents, then imports the contents of a spreadsheet into this table. It does not make sense to link this spreadsheet because sometimes it needs to be directly used/accessed for input.
My problem is that sometimes a user will open the spreadsheet - for whatever purpose - but if a user opens the database it will give an error message stating that it cannot find this spreadsheet. So the current workaround is that a user must let the other database users (five users total) know that they plan to open/use the spreadsheet.
Can someone please help me to add something to the Main Menu (On Load) macro so that it tests if the spreadsheet is open? If it is open then it will let the user know and will not execute the import process.
Any other ideas or suggestions are also welcome.
