Permission problems using MS Access database with ASP

need help with ms access permission problems

[Stroke]

hi, im rather new to both using access databases and asp, however after reading through the tutorials at w3schools.com i made a few pages to update, add, and delete records from a ms access database and all works fine, but as soon as i edit the database using access, say adding a new table, i cant access the database at all, even using the previous code that was working, now all i did was add a table and not touch any permissions at all believing that anyone can access the database...

so does anyone have any idea why this is happening?
any help would be greatly appreciated, thanks.

[le_gber]

Hi Stroke and welcome to Webmasterworld,

When do you experience this pb? is it when you test you site locally or is when your site is live on the internet?

Leo

[mattglet]

stroke,
if you could provide the actual error message, we could help you out a little better.

-Matt

[musicales]

Stroke - this is an annoying thing that's happened to me many times. When you save a new access database (for example by uploading it to the server) it makes it read only again. If you have access to the server you need to right click and allow write permission to the file. If you don't you'll have to ask the techs to do it for you. This is a big pain if you're setting something up and making a lot of changes -Sooo glad I have a dedicated server now (;

[Stroke]

the server is local, just using iis, and this is the actual error

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/custadd_add.asp, line 50

i used to run the database on a win98 pws server and got a similar error aswell, usually though when i update the db manually i do it on a file else where on the harddrive then upload/copy it to the iis webserver directory im not sure if that makes any difference?, also i have noticed since i installed iis, if i have a directory thats read only anywhere on my computer and i untick read only and hit apply it wont change from read only, very odd

[musicales]

stroke - it's not the read only checkbox I was thinking of, although that should be unchecked too, its right click - then select the security tab - then set write permission for 'IUSER_MACHINENAME' or 'EVERYONE'

[Stroke]

i have seen that mentioned in a few other posts, but i do not have that security tab, im running xp, using office xp if that makes a difference

[Stroke]

ahh i found the problem exactly as you said musicales but if your running winxp you must first turn off 'Simple File Sharing' from 'Folder Options' found in the Control Panel then the security tab comes up, thanks for your help, but just curious, has anyone ideas how i might go about setting up a user/pass for database access in the future?