problem conx MS acces with qlikview

[souadouert]

i tried connect qlikview to ms acces , but i had this error

"the microsoft access database engine could not find the object database"

i repair my db many time but doesnt work

[Miguel_Angel_Baeyens]

Make sure you are using the right driver. Uncheck 32 bits version and try with 64 bit version. You can also try defining a DSN with C:\Windows\System32\odbcad32.exe (there is another one under SysWO64 with the same name, that is for 32 bit connections)

[souadouert]

with others database ms access , it works succefully!!!!! but with this doesnt

[Miguel_Angel_Baeyens]

Are those .accdb or .mdb? Also, is this one locked or protected somehow?

[souadouert]

i dont think that , because i work with this ms db and talend data integration without problems

[Miguel_Angel_Baeyens]

So Compact and Repair didn't do the trick? Does it work if you open it manually in Access?

[souadouert]

i repaired with the option "compact and repair " the data base many times and i deleted all records 

[Miguel_Angel_Baeyens]

What if you save that file as a new one with a different name and try that one? Or to open that in a different computer with QlikView Desktop as well?

[souadouert]

i saved with different name also but doesnt work   i tried mani solutions

[souadouert · Accepted solution]

i found the solution