I'm trying to export the result of a query to another database by using the TransferDatabase function in either a Macro or VB (I've tried both, and neither of them work). The problem is that everytime I try to run it says that either this database is opened by another user exclusively (which it is not... it's closed and only on my computer) or you need permission to view its data.
Now, the receiving database has no username or password protection, and under the TOOLS>Security tab everything is checked, so full permission is given to this database.
Has anyone ever had a similar problem, and if so, how did you fix it?!?? This is so frusturating!