must use updateable query - how to set permissions?

[worldwise]

I can't figure out where to set permissions? I'm pretty sure it has something to do with the I_USER (internet guest user) account permissions. Where do I set these?

I'm running XP Home, ISS, MS Acces 2003. These pages work so I know it doesn't have anything to do with the code.

Thanks!

 

[PHV]

Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[worldwise]

I couldn't see in that link where it said anything about setting permissions.

 

[Golom]

Updatable queries are not associated with having (or not having) permissions.

A query will not be updatable if Access cannot determine which records to change in the underlying table(s). For example, UNION queries, GROUP BY queries, DISTINCT queries and OUTER JOIN queries are usually not updatable. You need to create a query that allows Access to relate what you are attempting to change with a specific field in a specific record in the base tables.

 

[worldwise]

the webpage works fine on my work computer. the problem is when i try to run the same code from my home. im 90% sure its a permissions problem.

can someone help tell me where to set permissions for internt guest users either on IIS or Access 2003?