Excel 07-Access 03 Data Link Issue
I have an Access db named City County Vendor Spend Rpt and an Excel workbook named INDY STAT - Local Spend.xls. The workbook has the spend info from Access linked into it. On an Access form, I have a button that opens the workbook via a module, which I have attached as "City County Vendor Spend Rpt.txt". When I click on the Access button to open the workbook, I get "You attempted to open a database that is already open exclusively by user....." then it asks me if I want to connect to the database, "yes" takes me to Data link properties where I change it to "share deny none" and click "ok". Well, I don't want to do all that. I want Access to open the workbook and refresh the data automatically upon opening without any messages. I can get the workbook to open without the messages if I make the button hyperlink vs using a module; however, it will not refresh the data automatically upon opening. Can anyone provide me a solution to my problem? Thank you!!!
|