By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,521 Members | 1,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,521 IT Pros & Developers. It's quick & easy.

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

P: 3
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
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 374
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.