Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    FYI The refresh works fine in Desktop with no errors appearing in Power Direct.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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.