472,374 Members | 1,602 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,374 software developers and data experts.

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 2694
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

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

Similar topics

by: TheCoder | last post by:
I am making a D-base with web conectivity for my class project. I have everything working but the subit button sends the data to the correct fields but afterwards it wants to reproduce new blank...
by: hotflash | last post by:
Hi All, I found the best pure ASP code to upload a file to either server and/or MS Access Database. It works fine for me however, there is one thing that I don't like and have tried to fix but...
by: dryajov | last post by:
NOTE TO MODERATOR: I'm reposting this thread here, please remove the duplicate from ACCESS/VBA forum. Thanks. Hi I'm not sure if this should go here in the first place, this is more likely an ODBC...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
by: Johno34 | last post by:
I have this click event on my form. It speaks to a Datasheet Subform Private Sub Command260_Click() Dim r As DAO.Recordset Set r = Form_frmABCD.Form.RecordsetClone r.MoveFirst Do If...
by: ezappsrUS | last post by:
Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...
by: jack2019x | last post by:
hello, Is there code or static lib for hook swapchain present? I wanna hook dxgi swapchain present for dx11 and dx9.
by: DizelArs | last post by:
Hi all) Faced with a problem, element.click() event doesn't work in Safari browser. Tried various tricks like emulating touch event through a function: let clickEvent = new Event('click', {...
by: F22F35 | last post by:
I am a newbie to Access (most programming for that matter). I need help in creating an Access database that keeps the history of each user in a database. For example, a user might have lesson 1 sent...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.