Hi,
I have made a query in my Access database, which I enter from an excel file I use for keeping a dashboard of the data. However, I cannot add new data to the access database without getting the error "the save action was cancelled" (although it is actually saved), while keeping the Excel file open. I hoped I could avoid this problem by instructing Excel to only update the data when the excel file is opened. Ideally I would like the excel data to be updated regularily without disturbing the use of Access for the one entering data into access.
I tried splitting the database, but I still got the same problem.
Hope the problem was understandable and that someone have a clue