When I am trying to connect to the Microsoft Access ODBC, I am getting below error.
I have Microsoft Access Driver 32/64bit installed.
When I replace database_file in [jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=database_file] with absolute path, it is giving me an error as below:
I have connected successfully to Access using Microsoft Access (Not ODBC). However, in the DBInput gives me an error when I am using below query:
[Select name from MsysObjects]
Component [DBInputTable:DBINPUT_TABLE3] finished with status ERROR. (Out0: 0 recs)
UCAExc:::4.0.2 user lacks privilege or object not found: MSYSOBJECTS
Thank you for your inquiry. Based on the error message, it appears the access file has some credentials that you may need to set in the connection. If you’re certain the access file isn’t protected by user credentials, then kindly try using “Admin” for username and leave the password blank. If this doesn’t work, then we would need to see the whole run log, as well as the connection dialog box. You can either print screen the connection dialog box or send us an externalized connection, whichever you prefer. Below is a link to the documentation on how to externalize database connections just in case. We look forward to hearing from you.
Some hint/tip (from the past).
1.) As i remember, may (just may) you don’t need to have rights for the sysobject.
(but you cant browse tables, forms may not work at all, etc.)
But may if you type the sql select or whatever manually (no table browsing) may works.
2.) Open the file in MSAccess, and some Security/Tools menu point you can add for your user the rights.
Some hint/tip (from the past).
1.) As i remember, may (just may) you don’t need to have rights for the sysobject.
(but you cant browse tables, forms may not work at all, etc.)
But may if you type the sql select or whatever manually (no table browsing) may works.
2.) Open the file in MSAccess, and some Security/Tools menu point you can add for your user the rights.
Regards: Andras,
“andras.csore”
Thank you for your reply Andras,
1.)If I type the query in MS Access itself, it worked fine.
2.)Just as mentioned in pointed one, I can access MsysObjects without any issue in MS Access. The error happens with Clover/UcanAccess.
Can you copy the full error log and paste it into a text document and attach it to your response? Also, what was the outcome of using “Admin” as username and leaving the password blank? We look forward to hearing from you.
