Hello,
I have Access/Excel 2007 and am using excel macros with ADO to create an .accdb file and loading a table from excel. I am then running my queries via the macro. I'm not real fluent with this process and the problem that I am running into is that when the .accdb file is created the associated .laccdb file is create...but when I close out of everything, the .laccdb file stays and I can't remove it without actually re-opening the .accdb file and closing.
Is there a line of code that I am missing that is not closing the file/removing the .laccdb?
I have Access/Excel 2007 and am using excel macros with ADO to create an .accdb file and loading a table from excel. I am then running my queries via the macro. I'm not real fluent with this process and the problem that I am running into is that when the .accdb file is created the associated .laccdb file is create...but when I close out of everything, the .laccdb file stays and I can't remove it without actually re-opening the .accdb file and closing.
Is there a line of code that I am missing that is not closing the file/removing the .laccdb?
