Hello,
I have an external source linked to my database (access 2010). The source is an Excel file stored on a SharePoint site within my network, I have full admin rights on that SharePoint as well.
So when I create a linked table it's all fine and everything works, but when I restart my computer and try to open the external source in my database it gives the error 'Failure creating file'.
I have tried changing to UNC instead of URL, but both encounter the same problem. What I don't understand is that my database imports it perfectly the first time and I can close/reopen Access and it will work but every time I restart my compute I get an error.
Anyone know a fix?