Hello Forum,
I didn't even know how to write the title of this thread… I really need help!
Ok… I had a spreadsheet -File1- that I linked as a table to my Access DB. I found out that, when File1 is open (because someone is updating it or whatever), I get error messages while in the DB (I don't remember in which case though, I didn't write it down).
therefore I created a new spreadsheet, File2 in which I copied File1 data with links. File2 has become my linked table in Access. This way, I don't mind if File1 is open or not, BUT:
- Do I need to go and open File2 from time to time in order to update the data that might have been changed in File1?
- Could I have kept File1 as a linked table thanks to a magic trick so Access wouldn't bother me if it was open or not?
Thank you for your time and your help. Have a great day all!
S.