Re: Must Use Updateable Query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ken Cox [Microsoft MVP] (BANSPAMken_cox_at_sympatico.ca)
Date: 01/16/05 

Date: Sun, 16 Jan 2005 08:13:36 -0500

Are you giving those rights to the correct user? If Anonymous isn't allowed,
this should tell you who you are dealing with:

 Response.Write(Web.HttpContext.Current.User.Identity.Name)

Ken

"Michael C#" <xyz@abcdef.com> wrote in message
news:GAmGd.2087$Su7.1507@fe08.lga...
> Thanks Ken, I found that link on a previous search. I've configured the
> settings on this box and the web directory to be as liberal as possible,
> but nothing seems to be working. I've changed the security settings in
> IIS to allow everything and even gave the IUSR_ Administrator rights to
> see if that was an issue. On the properties box in Windows Explorer for
> the folder, I've allowed everything!
>
> What security settings am I missing and how in the world can I set them in
> XP Pro?
>
> Thanks
>
> "Ken Cox [Microsoft MVP]" <BANSPAMken_cox@sympatico.ca> wrote in message
> news:ueIqax3%23EHA.2876@TK2MSFTNGP12.phx.gbl...
>> Hi Michael,
>>
>> This is usually caused by the current user - ASP.NET not having
>> sufficient privileges in the directory where the .mdb file is located.
>> Access needs to create a locking file when it is run... that requires
>> change permissions on the file and directory.
>>
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;316675
>>
>>
>> "Michael C#" <xyz@abcdef.com> wrote in message
>> news:8ZkGd.2079$3v6.1005@fe08.lga...
>>> Question - I keep getting the above error when I try to run an INSERT
>>> query against an Access database. I'm running XP Professional and
>>> VS.NET 2003. I run SELECT queries from ASP.NET against it all day long,
>>> and when I run the INSERT query inside Access itself, it works fine.
>>> But for some reason when I run it from within ASP.NET, I get the "Must
>>> Use Updateable Query" error. I've tried searching and have also tried
>>> setting the permissions on the directory to be as liberal as possible.
>>> Is there another security setting I'm missing? Or is there an
>>> incompatibility with my query? Or some other problem?
>>>
>>> TIA.
>>>
>>> Here's my code:
>>>
>>> Dim Con As New OleDb.OleDbConnection
>>> ("PROVIDER="Microsoft.Jet.OLEDB.4.0;DATA
>>> SOURCE=""C:\InetPub\wwwroot\Test1\STORE.MDB"";USER ID=Admin;PASSWORD=;")
>>> Con.Open()
>>> Dim Cmd As New OleDb.OleDbCommand("INSERT INTO [tblOrder] ([CustomerID],
>>> [Subtotal], [Tax], [Discount], [ShippingMethod], [ShippingCost],
>>> [Total], [OrderDate], [ShipName], [ShipAddress], [ShipCity],
>>> [ShipState], [ShipZIP], [CCNum], [CCExp]) VALUES (6, 190, 10.2885, 9.5,
>>> ""Express"", 10, 200.7885, ""1/15/2005 9:53:29 PM"", ""Joe Mocling"",
>>> """", ""Atlanta"", ""GA"", """", """", ""1/1/2005 12:00:00 AM"")", Con)
>>> Cmd.ExecuteNonQuery()
>>> Cmd.Dispose()
>>> Con.Close()
>>> Cmd.Dispose()
>>>
>>
>
>

Relevant Pages

  • Re: HELP with GPO security
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... I can't open Active Directory as domain admin to make any changes on = ... no way to change permissions, ...
    (microsoft.public.win2000.active_directory)
  • Re: Determining query rights.
    ... Is there any way to determine the security settings for a W2K domain? ... > domain using the effective rights tool. ... > Read permissions are required, as per membership of the Pre-W2K compatible ... >> I've been asked to check that a particular account in AD can query AD ...
    (microsoft.public.windows.server.active_directory)
  • Re: Deny account admins rights to change mailbox permissions
    ... I would be very surprised if View-Only Administrator role grants the right ... in a group that otherwise has rights to do this. ... groups that they're in and see if any have rights on the mailbox store, ... I have tried to deny the rights to change permissions ...
    (microsoft.public.exchange.admin)
  • Re: Share folder issue in ad environment
    ... And i meant the share permission and the folder security settings. ... This posting is provided "AS IS" with no warranties, and confers no rights. ... I added Domain admin and everyone account in share permission and ... "Meinolf Weber" wrote: ...
    (microsoft.public.windows.server.active_directory)
  • Re: Lock out 1 user within Enterprise Manager
    ... If they don't have sa or dbo rights they wont be able to change permissions. ... >>Make this person a member of the datareader role in the ... >>> to restrict rights because they'll definitely come tell ...
    (microsoft.public.sqlserver.security)