Forum Discussion
Ms Access Refresh - Error 2147467259
Hi,
I have an issue refreshing a Query from an Ms Access Database, returning the above error code. Error below.
I have read that this can be caused by changing the name of a table,tabs in the source etc, but that is not causing this.
This is the query I am connected to(Named exactly as above)
I am using an personal-mode gateway, doubt that causes this error. Is there anything within the Advanced Editor script that could cause this?
Any help to get my first scheduled dataset to run would be greatly appreciated :smileyvery-happy:
Thanks,
Barry.
4 Replies
Hi Anonymous
I cannot reproduce the same issue. Please check if the below post could help you.
Regards,
Cherie
v-cherch-msft Unfortunately, this didn't fix the error. I removed steps used in Power Direct changing any datatypes and republished the workspace. No Luck :smileysad:
ALSO If I try to connect to the database from the Dataflow service, I cannot even see the queries. My suspicion is that this error lies with trying to connect to a view instead of a table ?? I am the owner of the database so permissions shouldn't be an issue.
