MS Access ADODB Connection String - Invalid File Path, Does not Exist

[ironfelix717]

Nothing like a waste of time.

I moved some files around on a ADODB MS Access project i am working on.

Now the connection string is not being recognized by my client macro. Heres the catch.. one macro WITH THE SAME EXACT CONNECTION STRING connects fine. The next macro I get runtime error path does not exist. I renamed the database .accdb file and Excel still wants to be a PIMA.

There are no ambiguous files on my desktop. Theres only one database file on my desktop and its in the right folder. This is a matter of ADODB Library not doing its just correctly. I think....
There is a catch, that I am on a Mac and using Parallels, but doubt that is of any issue here.


Module 1 (works good) connection string:

Please Login or Register  to view this content.

Module 2 (runtime error) connection string:

Please Login or Register  to view this content.

Wow they're exactly the same.

However, the runtime error i get references this database....

Please Login or Register  to view this content.

Capture.PNG


Company is the old database name I had. It is no longer there. Its renamed.


I had this issue before. I fixed it. Can't remember how. But its a real PITA and frankly Its a waste of everyone's time. Any help is appreciated.

Thanks

[Norie]

Can you post the actual code that's causing the error?

[ironfelix717]

Norie,

Perhaps but would be tedious probably.

But I assure you nothing is being missed. The filename is correct. The connection strings are correct. And the error is still present. Its almost like the client is not re-freshing its connection (old database name). I even rebooted the virtual machine.