I am getting anerror when update the database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am getting this error messager "OPERATION MUST USE AN UPDATEABLE QUERY"
when uppdate the Access database. I have use the wizard to auto generate an
data input form. I have not modify the program at all. Can anyone tell me
what will be the problem?
 
Make sure that the folder that the database is in as well as the database
itself is giving the user the correct permissions for modification.
 
Have you verified that the UpdateCommand, InsertCommand and DeleteCommand
code was generated?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
William (Bill) Vaughn said:
Have you verified that the UpdateCommand, InsertCommand and DeleteCommand
code was generated?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Click to expand...
It has generate those code.
 
Scott M. said:
Make sure that the folder that the database is in as well as the database
itself is giving the user the correct permissions for modification.
Click to expand...
It is a local pc and the user login has admin rights. May be I am wrong.
Would you mind to show me how to check the admin rights. Thank You.
 
I had the same problem. It was the permissions of the folder that contains
the database.

Right click the folder that contains the database and choose "Properties".

Then click the "Security"tab.

Look at the users that are listed and make sure that the appropriate user
has at least "modify" permissions to the folder.

Now, right click on the database file itself and repeat the same steps.
 
Back
Top