Query error message

[Xenocide]

Hi

I create a program and put it on multiple computer. When someone try to use some query (mostly INSERT query) it write the message

This operation require a query that can be updated

Or something like that (actually it,s a traduction from french).

I really don'T know what this error his. On top of this it only affect one computer since the others can use the program and do the same operation without that message.

Can someone help me on that one?

 

[The_Doc_Man]

This is a stab in the dark, I'm assuming we are talking about front-end and back-end situations (with a shared back-end database file), and you might need some help from an experienced domain administrator, but this might be your problem:

If one person CANNOT do an update but everyone else CAN, and if the front end copies are really that - true copies - then the problem could be in the failing user's permissions to the back end database file itself or to the folder holding the back end file.

In order to update anything in an Access DB, you must be able to open the file in read/write mode. However, certain Windows File Permissions settings can prevent this. The quickest thing that would block you is if the user cannot create or update the .LDB file in the folder, since you cannot lock a record without being able to update the .LDB. If you can't LOCK the record, Access usually will not let you UPDATE the record, either.

So compare the permissions for the user having trouble to those of any user who is NOT having trouble. You are looking for something like the user who runs read-only has no permission to create a file in the back end file's folder. Or lacks WRITE permission. Or something along those lines. In the worst case, there might even be an explicit DENY permission, which is the ultimate disaster for this kind of thing.

If you don't understand this answer, show it to your domain administrator or the system administrator for the server holding the shared back end folder.

You must have nearly Full Control (everything except ADMINISTER, TAKE OWNERSHIP, CHANGE PROTECTIONS, things like that) over a folder holding an Access database. You have to be able to read, write, update, create, and delete files in that folder.