Send data to microsoft access

am 13.02.2007 00:19:14 von trig

Please help!

I am an ICT teacher at a secondary school and my year 12 (AS Level)
group need to create a website where data can be sent from a form to a
Microsoft Access database.

I am trying to do this in my own time and then hopefully teach them
how to do it.

I have installed IIS on my machine and have followed a few web
tutorials on how to get data from an Access database on to your
webpage which i've found quite easy.

The difficulty comes when i want to SEND data to my database using a
form.

I have created a database called "test.mdb"
The database has one table called "customer"
The customer table has 4 fields "ID" "Surname" "Forname" "Age"
The datatypes of the fields are "number" "Text" "Text" "number"
I have set no primary key (I believe that this might make it easier to
solve)

I am trying to keep it REALLY simple to start with and only sending
one piece of data to start with, that being a "Surname"

I have created a "form.asp" page with the following code:

I have then create a "send_data.asp" page that SHOULD recieve the data
and send it to the database, this is the code:

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "C:/Inetpub/wwwroot/test.mdb"

sql="INSERT INTO customer (Surname)"
sql=sql & " VALUES "
sql=sql & "('" & Request.Form("Surname") & "')"
on error resume next
conn.Execute sql,recaffected
if err<>0 then
Response.Write("No update permissions!")
else
Response.Write("

" & recaffected & " record added

")
end if
conn.close
%>

HOWEVER, when i press the "Add New" button on the "form.asp" page it
takes me to the "send_data.asp" page but all it says is:

No update permissions!

As far as i know i have checked the permissions of my database file
and i have full privilages but it won't send the data.

So to summarise i can request data from my database and it works fine
but i can not send data to it (Have tried so many on line tutorials).

Would really appreciate some help (in as much detail as possible
please - where i might have gone wrong - how to resolve the problem)

Thank you in advance

Trig

Re: Send data to microsoft access

am 13.02.2007 01:31:11 von reb01501

trig wrote:
>
> No update permissions!
>

All users of the database file need to be able to create, modify and
delete a locking file that has a .ldb extension in the folder that
contains the database file. This means that users need Change/Modify
permissions for the folder, not just the .mdb file. Who the users are
depends on what type of authentication your website is using. If using
Anonymous, then the IUSR_machinename account requires permission for the
folder. Otherwise, all the accounts of the users themselves need the
permissions. See:
http://support.microsoft.com/default.aspx/kb/253604
http://support.microsoft.com/default.aspx/kb/166029
http://support.microsoft.com/kb/253580/EN-US/

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: Send data to microsoft access

am 13.02.2007 01:31:20 von Bob Lehmann

>>> No update permissions!

Maybe it isn't a permissions error.

Remove the On Error and your error trapping, and you will see what the error
is.

Oh, and make sure you've unchecked the "Show Friendly Error Messages" if
using Internet Destroyer.

Bob Lehmann

"trig" wrote in message
news:1171322354.684207.30100@l53g2000cwa.googlegroups.com...
> Please help!
>
> I am an ICT teacher at a secondary school and my year 12 (AS Level)
> group need to create a website where data can be sent from a form to a
> Microsoft Access database.
>
> I am trying to do this in my own time and then hopefully teach them
> how to do it.
>
> I have installed IIS on my machine and have followed a few web
> tutorials on how to get data from an Access database on to your
> webpage which i've found quite easy.
>
> The difficulty comes when i want to SEND data to my database using a
> form.
>
> I have created a database called "test.mdb"
> The database has one table called "customer"
> The customer table has 4 fields "ID" "Surname" "Forname" "Age"
> The datatypes of the fields are "number" "Text" "Text" "number"
> I have set no primary key (I believe that this might make it easier to
> solve)
>
> I am trying to keep it REALLY simple to start with and only sending
> one piece of data to start with, that being a "Surname"
>
> I have created a "form.asp" page with the following code:
>
>
>

>
>
>
> I have then create a "send_data.asp" page that SHOULD recieve the data
> and send it to the database, this is the code:
>
>
>
>
> <%
> set conn=Server.CreateObject("ADODB.Connection")
> conn.Provider="Microsoft.Jet.OLEDB.4.0"
> conn.Open "C:/Inetpub/wwwroot/test.mdb"
>
>
> sql="INSERT INTO customer (Surname)"
> sql=sql & " VALUES "
> sql=sql & "('" & Request.Form("Surname") & "')"
> on error resume next
> conn.Execute sql,recaffected
> if err<>0 then
> Response.Write("No update permissions!")
> else
> Response.Write("

" & recaffected & " record added

")
> end if
> conn.close
> %>
>
>
>
>
> HOWEVER, when i press the "Add New" button on the "form.asp" page it
> takes me to the "send_data.asp" page but all it says is:
>
> No update permissions!
>
> As far as i know i have checked the permissions of my database file
> and i have full privilages but it won't send the data.
>
> So to summarise i can request data from my database and it works fine
> but i can not send data to it (Have tried so many on line tutorials).
>
> Would really appreciate some help (in as much detail as possible
> please - where i might have gone wrong - how to resolve the problem)
>
> Thank you in advance
>
> Trig
>

Re: Send data to microsoft access

am 12.04.2007 04:39:16 von unknown

under internet options in internet explorer tools click security, then internet, then custom level, then under user authentication check automatic logon with current username & password AND VOILA!!!! There you have it....
---
Posted via DotNetSlackers.com

Re: Send data to microsoft access

am 12.04.2007 13:17:30 von McKirahan

"trig" wrote in message
news:1171322354.684207.30100@l53g2000cwa.googlegroups.com...
> Please help!
>
> I am an ICT teacher at a secondary school and my year 12 (AS Level)
> group need to create a website where data can be sent from a form to a
> Microsoft Access database.
>
> I am trying to do this in my own time and then hopefully teach them
> how to do it.
>
> I have installed IIS on my machine and have followed a few web
> tutorials on how to get data from an Access database on to your
> webpage which i've found quite easy.
>
> The difficulty comes when i want to SEND data to my database using a
> form.
>
> I have created a database called "test.mdb"
> The database has one table called "customer"
> The customer table has 4 fields "ID" "Surname" "Forname" "Age"
> The datatypes of the fields are "number" "Text" "Text" "number"
> I have set no primary key (I believe that this might make it easier to
> solve)
>
> I am trying to keep it REALLY simple to start with and only sending
> one piece of data to start with, that being a "Surname"
>
> I have created a "form.asp" page with the following code:
>
>
>

" & recaffected & " record added

Re: Send data to microsoft access

am 12.04.2007 13:56:29 von reb01501

McKirahan wrote:
>
> Also, I'm not familiar with your use of "recaffected".

It's well-documented. The second argument of the Execute statement is a
byref argument that will contain the number of records affected by the
statement being executed after the execution occurs.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"