Welcome to HostingForumz.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

Can't write to Access

  
   Web Hosting Problem Solving Community! (Home) -> IIS RSS
Author Message
rosslockwood

External


Since: Nov 07, 2003
Posts: 1



(Msg. 1) Posted: Fri Nov 07, 2003 6:05 pm
Post subject: Can't write to Access
Archived from groups: microsoft>public>inetserver>iis (more info?)
I am developing a web site on my laptop, and running IIS on the same
machine.

For some reason I get an error from IIS to the effect that I cannot run an
update query against the Access database (I can read the database without a
problem, just not write to it).

It all works fine if I use Cassini or when I ftp the scripts to my ISP, just
doesn't work locally with IIS.

Anyone seen this before?

Ross

 >> Stay informed about: Can't write to Access 
Back to top
Login to vote
user1035

External


Since: Nov 02, 2003
Posts: 93



(Msg. 2) Posted: Fri Nov 07, 2003 6:05 pm
Post subject: Re: Can't write to Access [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
The database needs to have the "Right" permissions if you are trying to
update it via ASP or other internet/intranet based programs. Just go the
database and right click on it, choose the security tab and add the IUSR or
give the IUSR account at least the "Change" permission.

--


Thank you for your time and have a great day,

Carroll P. MacDonald
System Administrator
Webmaster
Microsoft Certified Professional
A+ Certified

® Carroll P. MacDonald Digital Drive
1668 Route 133
Grand Barachois, N.B.
E4P 8H5
Ph.: (506) 532-2013
Cell: (506) 531-0483
<a style='text-decoration: underline;' href="http://www.digitaldrive.ca/" target="_blank">http://www.digitaldrive.ca/</a> (work)
<a style='text-decoration: underline;' href="http://www.pegusisfreeware.com/" target="_blank">http://www.pegusisfreeware.com/</a> (personal)


"Ross" <rosslockwood DeleteThis @hotmail.com> wrote in message
news:3fab1a3f$0$3499$afc38c87@news.optusnet.com.au...
 > I am developing a web site on my laptop, and running IIS on the same
 > machine.
 >
 > For some reason I get an error from IIS to the effect that I cannot run an
 > update query against the Access database (I can read the database without
a
 > problem, just not write to it).
 >
 > It all works fine if I use Cassini or when I ftp the scripts to my ISP,
just
 > doesn't work locally with IIS.
 >
 > Anyone seen this before?
 >
 > Ross
 >
 ><!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Can't write to Access 
Back to top
Login to vote
user641

External


Since: Aug 22, 2003
Posts: 1637



(Msg. 3) Posted: Fri Nov 07, 2003 6:05 pm
Post subject: Re: Can't write to Access [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Ross" <rosslockwood DeleteThis @hotmail.com> wrote in message
news:3fab1a3f$0$3499$afc38c87@news.optusnet.com.au...
 > I am developing a web site on my laptop, and running IIS on the same
 > machine.
 >
 > For some reason I get an error from IIS to the effect that I cannot run an
 > update query against the Access database (I can read the database without
a
 > problem, just not write to it).

And what is this magical mysterious error???
<a style='text-decoration: underline;' href="http://www.aspfaq.com/database.asp" target="_blank">http://www.aspfaq.com/database.asp</a>

--
Tom Kaminski IIS MVP
<a style='text-decoration: underline;' href="http://www.iistoolshed.com/" target="_blank">http://www.iistoolshed.com/</a> - tools, scripts, and utilities for running IIS
<a style='text-decoration: underline;' href="http://mvp.support.microsoft.com/" target="_blank">http://mvp.support.microsoft.com/</a>
<a style='text-decoration: underline;' href="http://www.microsoft.com/windowsserver2003/community/centers/iis/" target="_blank">http://www.microsoft.com/windowsserver2003/community/centers/iis/</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Can't write to Access 
Back to top
Login to vote
anonymous77

External


Since: Oct 14, 2003
Posts: 468



(Msg. 4) Posted: Fri Nov 07, 2003 6:05 pm
Post subject: Re: Can't write to Access [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Thanks you for your help, but I am no further along with=20
this problem.

I have added the IUSR account to the perssions for the=20
MDB file, and I have also adjusted the file security=20
properties via IIS so that the MDB file has write and=20
modify enabled for the IUSR account.

I still get the error "Operation must use an updateable=20
query"

As I mentioned previously, Cassini has no problem with=20
this, why is it an issue with IIS?

kr
RossL


 >-----Original Message-----
 >The database needs to have the "Right" permissions if=20
you are trying to
 >update it via ASP or other internet/intranet based=20
programs. Just go the
 >database and right click on it, choose the security tab=20
and add the IUSR or
 >give the IUSR account at least the "Change" permission.
 >
 >--=20
 >
 >
 >Thank you for your time and have a great day,
 >
 >Carroll P. MacDonald
 >System Administrator
 >Webmaster
 >Microsoft Certified Professional
 >A+ Certified
 >
 >=AE Carroll P. MacDonald Digital Drive
 >1668 Route 133
 >Grand Barachois, N.B.
 >E4P 8H5
 >Ph.: (506) 532-2013
 >Cell: (506) 531-0483
 >http://www.digitaldrive.ca/ (work)
 >http://www.pegusisfreeware.com/ (personal)
 >
 >
 >"Ross" <rosslockwood.DeleteThis@hotmail.com> wrote in message
 >news:3fab1a3f$0$3499$afc38c87@news.optusnet.com.au...
  >> I am developing a web site on my laptop, and running=20
IIS on the same
  >> machine.
  >>
  >> For some reason I get an error from IIS to the effect=20
that I cannot run an
  >> update query against the Access database (I can read=20
the database without
 >a
  >> problem, just not write to it).
  >>
  >> It all works fine if I use Cassini or when I ftp the=20
scripts to my ISP,
 >just
  >> doesn't work locally with IIS.
  >>
  >> Anyone seen this before?
  >>
  >> Ross
  >>
  >>
 >
 >
 >.
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Can't write to Access 
Back to top
Login to vote
user641

External


Since: Aug 22, 2003
Posts: 1637



(Msg. 5) Posted: Fri Nov 07, 2003 6:05 pm
Post subject: Re: Can't write to Access [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
<anonymous DeleteThis @discussions.microsoft.com> wrote in message
news:00e501c3a4ed$7ae1ab00$a001280a@phx.gbl...
 >Thanks you for your help, but I am no further along
 > with this problem.

 >I have added the IUSR account to the perssions for the MDB file, and I have
also adjusted the file security properties via IIS so that the MDB file has
write and modify enabled for the IUSR account.

 >I still get the error "Operation must use an updateable query"


<a style='text-decoration: underline;' href="http://www.aspfaq.com/show.asp?id=2062" target="_blank">http://www.aspfaq.com/show.asp?id=2062</a>

--
Tom Kaminski IIS MVP
<a style='text-decoration: underline;' href="http://www.iistoolshed.com/" target="_blank">http://www.iistoolshed.com/</a> - tools, scripts, and utilities for running IIS
<a style='text-decoration: underline;' href="http://mvp.support.microsoft.com/" target="_blank">http://mvp.support.microsoft.com/</a>
<a style='text-decoration: underline;' href="http://www.microsoft.com/windowsserver2003/community/centers/iis/" target="_blank">http://www.microsoft.com/windowsserver2003/community/centers/iis/</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Can't write to Access 
Back to top
Login to vote
Display posts from previous:   
   Web Hosting Problem Solving Community! (Home) -> IIS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]