Hi,
I have linked excel files to my access database and wrote queries for data retrival. Now the problem is, when i open the linked table in Ms Access or run a query, I am not able to open the excel file at the same time. It says, "this file is in use. try again ".. Is there a solution that i can open the excel sheet while it is open in Access?