470,619 Members | 1,450 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,619 developers. It's quick & easy.

ODBC error "could not open file <path>\dba.mdb"

Hi I'm not sure if this should go here in the first place, this is more likely an ODBC driver issue.

I'm having the strangest behavior when trying to do an insert into an access database from a C++ application, thru ODBC. I'm able to successfully open a connection to the DB and perform selects, but when I try to do an insert the strangest thing happens, ODBC throws an error saying that it can't open the "dba.mdb" file, which is not the db file I have established connection to nor it is mentioned anywhere explicitly in the code... I'm stumped, it looks like for some reason the ODBC driver or access itself is trying to load this db for some reason. Any clue why?
I have read/write access to the DB file I'm connected.. Also, I don't have Access installed on the PC, but don't think it has anything do with it, (but I'm no expert in this filed so I might be/probably wrong.)

Any help is greatly appreciated.

Thanks in advance
Feb 15 '08 #1
1 2589
374 Expert 256MB
My only suggestion that I have for you is to make sure that you are current on ALL of your windows updates and especially your JET 4.0 updates. This way you won't have any issues with updating and writing to MS Access Database tables.

Do you know what version of the MS Access Database you are using?

Depending on how you're accessing your MS Access database with ADO, you also may have an outdated version of ADO depending on which version of MS Access database that you're connecting too?

You'll need to find out somehow with a copy of MS Access on someone's machine which version of MS Access MDB file it is?

This will help in troubleshooting your problem..

Hope that helps,

Joe P.
Feb 26 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

By using this site, you agree to our Privacy Policy and Terms of Use.