The Soccer Site

nexus990 · December 8th, 2004, 11:02 AM

I have installed the Soccersite on to my Webserver and the majority of it runs great. The problem I have is that I can not create, edit or delete any records from the soccer site database. I can retrieve data okay though.

I've checked the DSN and that appears okay.

Any suggestions?

Regards

Phil Thompson

Imar · December 8th, 2004, 02:27 PM

Hi Phil,

Are you getting a specific error message? Most likely, this has to do with permissions in the database folder, but only a detailed error message can confirm this....

Cheers

Imar

nexus990 · December 15th, 2004, 05:19 AM

Imar,

Thanks for the reply. I have checked the access rights to the database folder and I have full control over the folder. Here are the error messages I receive.

On the Delete event....

Microsoft JET Database Engine (0x80004005)
Could not delete from specified tables
/thesoccersite/admin/deleteEvent.asp, line 43

On the Create Event....

Microsoft Jet Database Engine(0x80004005)
Operation must use an updateable query
/thesoccersite/admin/createEvent.asp, line 138

On the Edit Event....
Microsoft Jet Database Engine(0x80004005)
Operation must use an updateable query
/thesoccersite/admin/updateEvent.asp line 131

Regards

Phil

Imar · December 15th, 2004, 05:59 AM

When you say "I have full control over the folder" are you referring to you r own account or to the Web server's? When you run an ASP page, by default it doesn't run with your security settings but with those of a special account used by the Web server.

Make sure the account IUSR_MachineName where MachineName is the name of your computer has change permissions on the database folder too.

Cheers,

Imar

nexus990 · December 15th, 2004, 06:17 AM

Thanks Imar,

The problem is now sorted.

Thanks again for all your help.

Regards

Phil

Imar · December 15th, 2004, 06:24 AM

Great. Just for the record (for any future visitors to this thread), was it the IUSR account that did the trick?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

nexus990 · December 15th, 2004, 11:31 AM

Imaar,

That is correct.
Thanks

Phil

wayne_87 · December 24th, 2004, 05:23 AM

Hello Imar, I have the same problem. I receive an error when deleting or updating from or a database(access 2000).
I wanted try your solution but somehow I don't understand it(I'm not an expert in networking).
Can you post me a more specific solution?
Thanks!

Imar · December 24th, 2004, 07:36 AM

Hi Wayne,

Check out this FAQ at my site: http://Imar.Spaanjaars.Com/QuickDocId.aspx?QUICKDOC=263
It describes how to resolve this problem in full detail.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.