updateable query error (I've read the MS stuff)

This is a discussion about updateable query error (I've read the MS stuff) in the Windows Networking category; I got the following error when trying to INSERT INTO a database: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Operation must use an updateable query. According to microsoft's support site, The most common reason is that the Internet Guest account (IUSR_MACHINE), which is by default part of th ...

Windows Networking 2246 This topic was started by ,


data/avatar/default/avatar03.webp

101 Posts
Location -
Joined 2000-12-27
I got the following error when trying to INSERT INTO a database:
 
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
 
According to microsoft's support site, "The most common reason is that the Internet Guest account (IUSR_MACHINE), which is by default part of the "Everyone" group, does not have Write permissions on the database file (.mdb). To fix this problem, use the Security tab in Explorer to adjust the properties for this file so that the Internet Guest account has the correct permissions."
 
The problem is, how do I do what they told me to? I see no security tab on the file's properties, and I can't find the "everyone" group (I could in win2k, but can't in XP)

Participate in our website and join the conversation

You already have an account on our website? To log in, use the link provided below.
Login
Create a new user account. Registration is free and takes only a few seconds.
Register
This subject has been archived. New comments and votes cannot be submitted.

Responses to this topic


data/avatar/default/avatar19.webp

3857 Posts
Location -
Joined 2000-03-29
Is the partition NTFS? If so, then open up Windows Explorer and go to Tools>Options, and scroll to the bottom. Then, uncheck "Use simple file sharing". I believe that will enable the security tab for you (I only use domains, so this is disabled by default). At that point, when you right click on the file you will then see a "Security" tab and you should be able to check its permissions.

data/avatar/default/avatar03.webp

101 Posts
Location -
Joined 2000-12-27
OP
Thanks a lot. Saved me a lot of hassle. Until now I was using brinkster to test my code and that's just a pain =)