Data Entry to Access MDB via asp web page

ok first tutorial sailed through, the next one adding brings back a 500 internal server error ???? this is my code for the adapted "Add_to_comments.asp" page my page is called "add_to_exhibitor_cat_entry.asp" :-

<%
'Dimension variables
Dim adoCon          'Holds the Database Connection Object
Dim rsAddCatentry   'Holds the recordset for the new record to be added
Dim strSQL          'Holds the SQL query to query the database
 
'Create an ADO connection object
Set adoCon = Server.CreateObject("ADODB.Connection")
 
'Set an active connection to the Connection object using a DSN-less connection
adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("cat_entry_info.mdb") 
 
'Create an ADO recordset object
Set rsAddcatalogueentry = Server.CreateObject("ADODB.Recordset") 
 
'Initialise the strSQL variable with an SQL statement to query the database
strSQL = "SELECT tblcatalogueentry.Contact_name, tblcatalogueentry.Contact_email, tblcatalogueentry.Company_name, tblcatalogueentry.Tel, tblcatalogueentry.Fax, tblcatalogueentry.Website, tblcatalogueentry.General_email, tblcatalogueentry.Company_description FROM tblcatalogueentry;"
 
'Set the cursor type we are using so we can navigate through the recordset
rsAddcatalogueentry.CursorType = 2
 
'Set the lock type so that the record is locked by ADO when it is updated
rsAddcatalogueentry.LockType = 3
 
'Open the recordset with the SQL query 
rsAddcatalogueentry.Open strSQL, adoCon
 
'Tell the recordset we are adding a new record to it
rsAddcatalogueentry.AddNew
 
'Add a new record to the recordsethn    
rsAddcatalogueentry.Fields("Contact_name") = Request.Form("name")
rsAddcatalogueentry.Fields("Contact_email") = Request.Form("email")
rsAddcatalogueentry.Fields("Company_name") = Request.Form("Cname")
rsAddcatalogueentry.Fields("Tel") = Request.Form("t")
rsAddcatalogueentry.Fields("Fax") = Request.Form("f")
rsAddcatalogueentry.Fields("Website") = Request.Form("w")
rsAddcatalogueentry.Fields("General_email") = Request.Form("ge")
rsAddcatalogueentry.Fields("Company_description") = Request.Form("cd")
 
'Write the updated recordset to the database
rsAddcatalogueentry.Update
 
'Reset server objects
rsAddcatalogueentry.Close
Set rsAddcatalogueentry = Nothing
Set adoCon = Nothing
 
'Redirect to the guestbook.asp page
Response.Redirect "company_info.asp"
%> 

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:

If using IE go to Tools, Internet Options... and click the Advanced tab.
Then scroll down until you see an option called "Show friendly HTTP error messages" and UNCHECK it.

Never have this checked when writing code :) When you run the page it should now give you an error and a line number.

Database error for read/write permissions so now sorted . . . i am working my way through the remainder of the guide and have a few other bits . . . . so watch out !

Ok so i have follwed these step by step guides . . ..  and understand how the database is connecting ! and managed to get it adding, deleting and updating  , , , so how do i know go about integrating this onto the asp pages via xml content ?? and css styling ?

Unless you _need_ XML I wouldn't complicate matters with it.

You say you have managed to get it updating. How are you doing this? If it is a form that populated the fields with database info for the user to edit and then click save (or similar) then the 'display' page will be pretty similar - just write the info to the page.

If, however, you don't actually have a way to edit then I here's how in pseudo code.

Open a connection to the database
define your sql statement
set your recordset object with the results of the sql query
Use getrows() to pull the info from the recordset into an array
close the database

What you will have then is an array with all the info in. This will always be a 2D array whether only one records are retrieved or many.

If you want to display a list then create a table with 2 rows: the first for the column headers and a second inside a for loop that will loop through your content array and display the appropriate info.

Of, if you just want to display one record then create a table or whatever layout you wish to use, then simply response.write() the bits of the array you wish to display to the user.

ok thats all sounds good but i am getting this error when trying to update the data in the database now ....

ADODB.Recordset error '800a0cb3'

Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.

/data/update_cat_entry.asp, line 31

This is usually the line that is something like:

'Set the lock type so that the record is locked by ADO when it is updated
rsAddcatalogueentry.LockType = 3

Try setting the locktype to 2 or if that doesn't work try -1 :)
Don't use 1 (that's read only) or 4 (for batch updates)

Another one that catches people out when using Access is this:
 The database MUST be editable by the user set in your web server

To clarify:
Whenever a file is requested from a web server that file will be accessed by a window user account. By default, IIS creates a user called IUSR_MACHINENAME (where MACHINENAME is the 'name' of your pc/server etc).
By default this user is a member of guests and can't log on.

So, this user needs to have read access to the files your web server needs to dish out.
If accessing an Access database it therefore also needs permission to read it. And, if you want to write to the database, it needs permission to edit it too.

If using IIS, open it, find your site in the list on the left, right click it and click Properties. Under the Directory Security tab click the Edit button next to Authentication and Access Control.
If hte user is "IUSR_servername" then that's fine, click cancel to close all the windows.
Next, go to the folder where the database is, right click it and hit properties.
Click the security tab.
If the IUSR_servername IS on the list make sure it is CHECKED under ALLOW and next to Modify. If not, check it and hit APPLY. Then, while this window is open, click ADVANCED.
Uncheck the "Inherit from parent blah blah blah" and check the "Replace permission entries blah blah blah".
What this will do is make sure that the web user has access to the database and can write to it.

Then give it another go.

(Usually when setting up a site all this security stuff is part of it. But if you're new to DB driven sites there can be several little things like this that get in the way. But once you know 'em you're off!)

good luck :)

Ok I have now managed to get the form online but am getting an error about where the database is held :Server.MapPath() error 'ASP 0172 : 80004005'

Invalid Path

/company_info.asp, line 17

The Path parameter for the MapPath method must be a virtual path. A physical path was used.

i have the included code on this line, what have i done wrong ????

 'Set an active connection to the Connection object using a DSN-less connection
adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("d:\customer\eurobusxpo\database\cat_entry_info.mdb") 

                                              

1:
2: