Need to resolve "microsoft jet database engine operation must use an updateable query" error using integration manager.

(0) Share

Report

Posted on by Cheryl L

147

I have a user that we just migrated over to a new Windows 7 machine from XP.. Great Plains was installed, the ODBC created for 64 bit operation, all works fine in GP. When using Integration Manager (brought IM folder over from her old machine), she tries to update info and receives the "microsoft jet database engine operation must use an updateable query" error.

I am not sure where to look to get past this. From what I have read, it is a permissions error. We brought her old system back up and verified that she was still able to perform this action there. A number of users have recently had their systems upgraded and we have not experienced this type of issue. One item of note (in my opinion) is that this upgrade tech used the migration tool, where as I had just manually brought files over on others. Perhaps there is a file or folder that needs to be eliminated that was transferred over? Or a path pointing to her old machine? Any ideas would be greatly appreciated!

Cheryl

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

Community Member on at

Like (0)

Report

Right-click the IM icon and select Run As Administrator

Was this reply helpful? Yes No
Suggested answer

Cheryl L 147 on at

Like (0)

Report

All is well now...I wound up testing the actual Access file from the user's login....it would open, but not after allowing the "trust" of this data base access. I suspect it was due to Office versions as we now use Office 2010 and it may have originally been created in 2003 (or earlier!). Once those were trusted, she was able to perform the information updates. Thank you for listening!

Was this reply helpful? Yes No