Access and Successfully Inserting a Record/not happening 1

[mindeye]

HELP!!!
1 I created an ASP form page and under Server Behaviors(using a Connection String) successfully connected to a Database on the server. (I know cause I can see the fields).

2. The my Server Definition is set to ASP 2.0 and VB

3. My form page is mostly Checkboxes w/ a couple of text fields. Each one has a unique name. The Checkbox Value is set to "ON".

4. In my Insert Record dialogue I have set the Checkboxes to Microsoft Access checkboxes and text to text. In Access my checkboxes are set to Y, N and my text fields are set to Text.

5. In my Form Name my settings are
<form ACTION=&quot;<%=MM_editAction%>&quot; METHOD=&quot;POST&quot; name=&quot;maintsurvey&quot;>

6. When I test it won't post the info to the Database record, and it won't send me 'After Inserting: Go to&quot; file.

Any help would be greatly appreciated.

Thanxz,
mindeye

 

[schase]

ok, what does it do?

any error messages on the browser? &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart

 

[mindeye]

It does a 404...File not Found

 

[schase]

ok couple things to check,

first on Internet Explorer, goto Tools, Internet Options, then advance tab - make sure &quot;Show friendly HTTP Error Messages&quot; is unchecked.

Retry the form to see what error message it gives you then.

And with the server behavior window, see if you have any red marks next to your insert behavior.

If none - dbl click the insert behavior - and make sure the fields match up on the bottom side of the command, and make sure the proper database connection and table are selected.

Post back results pls. &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart

 

[mindeye]

okay this is the browser message

I.

ADODB.Command error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/_data/maintConfSurv.asp, line 88

II.

line 88 is a comment line

' execute the insert

III.

I am getting a message when I click on the Form Elements under Insert Record:

&quot;The original column line specified in this script was not found.&quot;

The checkbox name in my form matches the column name in my Access Database Record. I have my Form Checkbox Value set to &quot;ON&quot;, and my Insert Behavior Form Element > Checkbox is set to Microsoft Access Checkbox, how ever I did try Checkbox 1,0

 

[schase]

ok,

If it were me, I would delete every Server behavior.

leaving just html on the page.

Then redo the recordset, and insert behavior.

Let us know how it comes out. &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart

 

[mindeye]

I deleted the Server Behavior. I then re-Inserted Record. I am still getting the same error. That line 88 is causing an error:
This is line 88 in my asp file.
' execute the insert

Humbled,
mindeye

 

[schase]

Ok,

well you would get the error on 88. Thats just the line that says to go ahead and do this.

ok, next items to check.

First - are you filling out every field on the form
Second - is every field in the database table in the form?
Third - Open the insert behavior - set the checkbox to ignore.

Then if more errors

Post the names of your fields in the database table here.

as well as how you have your form field names. &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart

 

[mindeye]

I have no red marks beside the record.
I am using every field.
I have one keyfield called ID that does not show up in the insert record field names.

Here are the files.

http://www.lce.com/_data/maintConfSurv.asp

http://www.lce.com/_data/maintConf.mdb

Here is the ASP connection script.
<%
' FileName=&quot;Connection_ado_conn_string.htm&quot;
' Type=&quot;ADO&quot;
' HTTP=&quot;true&quot;
' Catalog=&quot;&quot;
' Schema=&quot;&quot;
MM_csmaintconf_STRING = strConn = &quot;Provider=Microsoft.Jet.OLEDB.4.0; Data Source=&quot; & &quot; d:\web\cprice\lce.com\_data\maintConf.mdb&quot;
%>

Thanks for Your Time,
Roger

 

[schase]

well lemme think.

I got an

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

error.

Curious - why the checkbox's in Access? How are you planning on pulling the data out later on?

And what was the reason behind setting a value of ON for the checkbox's in the asp page? &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart

 

[mindeye]

I set the items to &quot;ON&quot; because I wasn't sure what else to set it to. I am new at this. I guess I could have set it to &quot;1&quot;?? Whatever will make it check the checkbox in access when it is enabled on the form. Any suggestions would be helpful. I looked at another form which checkbox values were set to one. This is the basis behind why I did it. I don't know better.

Thanks,
Roger

 

[schase]

no please dont get me wrong, it was curiosity more than anything else.

Ok, heres the process I go through when designing a new form.

First - checkbox's are cool on the form page - but will only one box be checked per question, or can many?

Second, how do you want to pull the info back out?

For now lets assume you want to use any possiblity of checkbox's per question.

Ok, then set the checked value in the form to 1 (or Yes or True).

this *should* make the box in access check off as true.

Give that a shot and lemme know. &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart

 

[mindeye]

The final mdb Record will only be viewed and perhaps responded to. There will be no conversion or record keeping except for maybe email addresses.


Multiple checkboxes can be checked which is why I used checkboxes vs radio buttons.

I have tried 1 and Yes and True. I get the same Error.

Thanx,
Roger

 

[schase]

ok send me the page via email.

schase@elpasohonda.com &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart

 

[mindeye]

I think my Permissions might not be set up right...