Hi, I've just installed IIS on my XP Pro computer so i can use my ASP pages and to test if thay are working!!. The problum i am having is when i go to my ASP pages it WORKS exepted when i go and try to post some infomation to my database using ASP in to a .mdb database and when i do it gives me a error of:- ------------------------------------------------ Technical Information (for support personnel) Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /ticket/add.asp, line 37 Browser Type: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; InfoPath.2) Page: POST 94 bytes to /ticket/add.asp POST Data: name=jy&surname=jyt&house=Harvey&emailaddress=jty&uyear=7&gender=Male&submit=Reserve+My+Ticket Time: 22 June 2008, 11:05:52 AM ------------------------------------------------ But when I put it on a web hosting server it WORKS fine??? If any one else had this problum please reply to help me fix this Thanks CutDMX12
Does the user IIS is running as have access to the directory that the database is located in? "CutDMX12" wrote: > Hi, > > I've just installed IIS on my XP Pro computer so i can use my ASP pages and > to test if thay are working!!. > > The problum i am having is when i go to my ASP pages it WORKS exepted when i > go and try to post some infomation to my database using ASP in to a .mdb > database and when i do it gives me a error of:- > ------------------------------------------------ > Technical Information (for support personnel) > > Error Type: > Microsoft JET Database Engine (0x80004005) > Operation must use an updateable query. > /ticket/add.asp, line 37 > > > Browser Type: > Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET > CLR 2.0.50727; .NET CLR 3.0.04506.30; InfoPath.2) > > Page: > POST 94 bytes to /ticket/add.asp > > POST Data: > name=jy&surname=jyt&house=Harvey&emailaddress=jty&uyear=7&gender=Male&submit=Reserve+My+Ticket > > Time: > 22 June 2008, 11:05:52 AM > ------------------------------------------------ > > But when I put it on a web hosting server it WORKS fine??? > > If any one else had this problum please reply to help me fix this > > Thanks > CutDMX12
Yes I Think "wdudek" wrote: > Does the user IIS is running as have access to the directory that the > database is located in? > > "CutDMX12" wrote: > > > Hi, > > > > I've just installed IIS on my XP Pro computer so i can use my ASP pages and > > to test if thay are working!!. > > > > The problum i am having is when i go to my ASP pages it WORKS exepted when i > > go and try to post some infomation to my database using ASP in to a .mdb > > database and when i do it gives me a error of:- > > ------------------------------------------------ > > Technical Information (for support personnel) > > > > Error Type: > > Microsoft JET Database Engine (0x80004005) > > Operation must use an updateable query. > > /ticket/add.asp, line 37 > > > > > > Browser Type: > > Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET > > CLR 2.0.50727; .NET CLR 3.0.04506.30; InfoPath.2) > > > > Page: > > POST 94 bytes to /ticket/add.asp > > > > POST Data: > > name=jy&surname=jyt&house=Harvey&emailaddress=jty&uyear=7&gender=Male&submit=Reserve+My+Ticket > > > > Time: > > 22 June 2008, 11:05:52 AM > > ------------------------------------------------ > > > > But when I put it on a web hosting server it WORKS fine??? > > > > If any one else had this problum please reply to help me fix this > > > > Thanks > > CutDMX12