Error when exporting data from access

[kristie ann]

Hey all,
I have exported data from an access table to excel using a macro, which is working perfect. The data in the access table is being gathered from a web front end.

However, when I have my excel worksheet open, and at the same time try to make changes to the underlying database via the web front end, I keep getting the error
Operation must use an updateable query

Is there any way to solve this problem so that I won't get this error in the web front end

Thanks
Kristie ann

[buntine]

Both MS Access and MS Excel will not allow the contents of a database or spreadsheet to be altered while it is active.. That is what your error is referring to.

To my knowledge, there is no way around this.