Hi guys,
I'm having a bit of an issue with something, and I don't know where to go with it. I'm trying to connect to an access database via ADO, and every time I try and connect to it, I keep getting the following error:
By searching on the net, I think I've figured out that it is looking for a system.mdw file. The person has emailed me all the files form the directory, though, and there is no system.mdw file in there, although there are a bunch of API files, if that's important.Originally Posted by Stupid Message Box
What's weird is that I can open the database file manually, I just have to enter the password (and yes, I am providing it via code), and I've been able to do that since I only had the db file and not the entire directory.
The line of code that gets stuck is this one:
[vba]cnt.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sdbpath & strdb & ";Password=thepassword;"[/vba]
I have made this work for a database of my own creation, but I do know that this particular database is launched via an .exe file (not made by me.)
Anyone have any idea of how I can get at it via code? Will DAO get me there? And if so, how the heck do I set up a connection that uses a password. The help files have proven useless to me so far.
Thanks!