Access permissions - operation must use an updatable query

[Guest]

Hi, I am currenty trying to make a Visual Basic /access Application
executable. The app works perfectly when i run it from VB, but when I run the
executable and try to update the database I am getting the following error -
opeation must use an updatable query. I have being trying to reaearch it and
I think its something do do with permissions? I have the database in a folder
- would this matter?
Any ideas would be greatly appreciated
Jill

 

[Naresh Nichani MVP]

Hi:

This generally means you are trying to update data in a query which is not
updateable. For exampe you have a query which has a Group By clause and does
a Total - such a query contains a data set which is not updateable i.e. you
cannot update data in it. Make sure the dataset or recordset in query is
updateable (a Select query with no Group By Clause is noramlly updateable).

Regards,

Naresh Nichani
Microsoft Access MVP

 

[Guest]

Thanks
But when i was running the project from visual basic I was not getting this
error.. Its only now that i have made the Visual basic executalble. So if the
query was working before I dont understand why it should not work now?? any
of my query's reading from the database are working correctly, its only when
i try to add or change something from the executable that the error occurs
Jill