Scott, thank you. We'll have an expert soon to look at it. I will try to post the solution here. Thanks again.

Basically this is one 76 MB size of mdb file. When I click on the file it opens it in Access and I see different records on the right pane, I click on any of them and get this error message, ODBC--Connection to 'accessODBC' failed.
I am not sure but maybe this database was created with Oracle and Access is not able to open/view it because it doesn’t have the right ODBC. I am not sure even if this makes sense to you.

Thanks...

Hi,

I have a file "filename.m db" i am trying to open this with MS Access 2003 and I get the error message: ODBC--Connection to 'accessODBC' failed.

Unfortunately I have no knowledge about how databases work. I was told that I needed to have the driver Microsoft ODBC for Oracle, which I already have.

Please help, i wasted so much time already trying to figure this out with zero database experience....