phantom
|
| Posted: 07/12/2001, 10:30 PM |
|
I am testing a database "Create Automatic" Connection String (via Access
2000), so it is easier to unload (I am persuming it is DSN-less) once I
uploaded, and try to edit or insert a new record I get this error message.
"Operation must use an updateable query. (Microsoft JET Database Engine)"
What does this problem mean? and is it my server that is causing this
problem or is it a program bug? Any solutions?
Thanks.
|
|
|
 |
CodeCharge
|
| Posted: 07/12/2001, 11:39 PM |
|
If you know the exact Error Code (your browser should display it), plug into
Google (google.com) and you will find your answer.
As far as I know, this error usually means that the user doesn't have
permissions to write to the database.
You may need to right-click on your database file (.mdb) and deselect "read
only", or change file security so that everyone can write to it.
"phantom" <pahntom@phantom.com> wrote in message
news:9im127$m2a$1@news.codecharge.com...
> I am testing a database "Create Automatic" Connection String (via Access
> 2000), so it is easier to unload (I am persuming it is DSN-less) once I
> uploaded, and try to edit or insert a new record I get this error message.
>
> "Operation must use an updateable query. (Microsoft JET Database Engine)"
>
> What does this problem mean? and is it my server that is causing this
> problem or is it a program bug? Any solutions?
>
> Thanks.
>
>
>
>
>
>
>
|
|
|
|
Ann Harrell
|
| Posted: 07/13/2001, 8:22 AM |
|
That's what it means alright. Sometimes when databases ae moved or uploaded
the permissions get changed to read only.
Ann
"CodeCharge" <support@codecharge.com> wrote in message
news:9im52s$tl9$1@news.codecharge.com...
> If you know the exact Error Code (your browser should display it), plug
into
> Google (google.com) and you will find your answer.
>
> As far as I know, this error usually means that the user doesn't have
> permissions to write to the database.
> You may need to right-click on your database file (.mdb) and deselect
"read
> only", or change file security so that everyone can write to it.
>
>
>
>
> "phantom" <pahntom@phantom.com> wrote in message
>news:9im127$m2a$1@news.codecharge.com...
> > I am testing a database "Create Automatic" Connection String (via Access
> > 2000), so it is easier to unload (I am persuming it is DSN-less) once I
> > uploaded, and try to edit or insert a new record I get this error
message.
> >
> > "Operation must use an updateable query. (Microsoft JET Database
Engine)"
> >
> > What does this problem mean? and is it my server that is causing this
> > problem or is it a program bug? Any solutions?
> >
> > Thanks.
> >
> >
> >
> >
> >
> >
> >
>
>
|
|
|
|
Anthony Trotter
|
| Posted: 07/13/2001, 2:11 PM |
|
Change the folder on your server containing your db from read to
write. This error typically means that your Web users do not have
permission to write to the db.
"phantom" <pahntom@phantom.com> wrote in message
news:9im127$m2a$1@news.codecharge.com...
> I am testing a database "Create Automatic" Connection String (via
Access
> 2000), so it is easier to unload (I am persuming it is DSN-less)
once I
> uploaded, and try to edit or insert a new record I get this error
message.
>
> "Operation must use an updateable query. (Microsoft JET Database
Engine)"
>
> What does this problem mean? and is it my server that is causing
this
> problem or is it a program bug? Any solutions?
>
> Thanks.
>
>
>
>
>
>
>
|
|
|
|
|
