CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Operation must use an updateable query. (Microsoft JET Database Engine

Print topic Send  topic

Author Message
zfxdfs
Posted: 06/02/2001, 6:18 PM

what is wrong?
how do i fix this?
thanks for any help!

Kelvin Chua
Posted: 06/02/2001, 6:20 PM

Is your ACCESS database writable??? or just readonly attributes??

Thanks.

Kelvin Chua
SINGAPORE

"zfxdfs" <fsdf@TGFD.NET> wrote in message
news:9fc38t$8m6$2@mail.tankhill.com...
> what is wrong?
> how do i fix this?
> thanks for any help!
>
>

A McFadyen
Posted: 06/04/2001, 1:06 AM

Check out the folder your database is stored in; you must be able to write
to that directory, as well as to the database.

Alistair McFadyen


"zfxdfs" <fsdf@TGFD.NET> wrote in message
news:9fc38t$8m6$2@mail.tankhill.com...
> what is wrong?
> how do i fix this?
> thanks for any help!
>
>

Hellen
Posted: 06/04/2001, 2:01 AM

Hi,
The error you are getting indicates that the database access permissions are
not set correctly. For starters, if you are using Windows NT or 2000, please
set the security on the .mdb file and its parent directory to "full-access".
If you use Windows 95/98/Me, right-click on the .mdb file and make sure that
"read-only" is unchecked, then do the same on the directory where your .mdb
file is located. Also, note the following:

1) This error may occur if the account being used by Internet Information
Server (IIS), (usually IUSR), does not have the correct Windows NT
permissions for a file-based database or for the folder containing the file.

2) Use the Windows NT File Monitor to check for file access failures.
Windows NT File Monitor is available from the following Web site:
<http://www.sysinternals.com>.

3) If you use a network path to the database (UNC or mapped drive), check
the permissions on the share, the file, and the folder.

4) Check to make sure that the file and the data source name (DSN) are not
marked as Exclusive.

5) Make sure no other process uses this mdb file.

6) This error may also occur when accessing a local Microsoft Access
database linked to a table where the table is in an Access database on a
network server. In this situation, please refer to the following article in
the Microsoft Knowledge Base for a workaround.

This error is attributed to the design of Microsoft products and you can
read more about it at:
PRB: ASP Returns 'Operation Must Use an Updateable Query' Error
http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP

Regards,
CC Support
"zfxdfs" <fsdf@TGFD.NET> wrote in message
news:9fc38t$8m6$2@mail.tankhill.com...
> what is wrong?
> how do i fix this?
> thanks for any help!
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.