<div>
I don't use Free ASP Upload, I used Persits ASPUpload, but the scripts should be similar. &nbsp;The first page of code is the page that uploads an image to a directory and updates an existing record in an Access db. &nbsp;The second page is the one that submits information. 

<pre><code class="code-100 nolinks" id="code-1027455">&lt;%
Set Upload = Server.CreateObject(&quot;Persits.Upload&quot;)

thePath = Session(&quot;FolderPath&quot;)
Upload.SetMaxSize 500000, True 'Limit image size
' Intercept all exceptions to display user-friendly error
On Error Resume Next 
Upload.Save(thePath)

' Error Check
loadStr = &quot;&quot;
' 8 is the number of &quot;File too large&quot; exception
If Err.Number = 8 Then
 Msgstr = &quot;Your submitted file is too large, going back..&quot;
 loadStr = &quot;goBack();&quot;
Else
 If Err &lt;&gt; 0 Then
 Msgstr = &quot;An error occurred with your image, going back..&quot;
	 loadStr = &quot;goBack();&quot;
 End If
End If

' Intercept all exceptions to display user-friendly error
On Error Resume Next

For Each File in Upload.Files
	If File.ImageType = &quot;UNKNOWN&quot; Then
		Msgstr = &quot;This is not an image file, going back..&quot;
		loadStr = &quot;goBack();&quot;
	End If
Next
Set conn = Server.CreateObject(&quot;ADODB.Connection&quot;)
'conn.ConnectionTimeout = 10
'conn.CommandTimeout = 10
'conn.Mode = 3
conn.open &quot;DBQ=&quot; &amp; Server.MapPath(&quot;_database/Rides.mdb&quot;) &amp; &quot;;Driver={Microsoft Access Driver (*.mdb)};&quot;
Set rs = Server.CreateObject(&quot;ADODB.Recordset&quot;)

sql = &quot;SELECT * FROM MyRide WHERE Username='&quot; &amp; Upload.Form(&quot;UserName&quot;) &amp;&quot;'&quot; 
'Response.Write sql
rs.Open sql, conn, 3, 3

rs(&quot;FirstName&quot;) = Upload.Form(&quot;FirstName&quot;)
rs(&quot;LastName&quot;) = Upload.Form(&quot;LastName&quot;)
rs(&quot;Make&quot;) = Upload.Form(&quot;Make&quot;)
rs(&quot;Model&quot;) = Upload.Form(&quot;Model&quot;)
rs(&quot;YearMade&quot;) = Upload.Form(&quot;YearMade&quot;)
rs(&quot;Email&quot;) = Upload.Form(&quot;Email&quot;)
rs(&quot;features&quot;) = Upload.Form(&quot;Features&quot;)

' Lets loop through and update the file name and description to the db

i = 1
For Each File in Upload.Files 
	rs(&quot;Description&quot;&amp;i&amp;&quot;&quot;) = Upload.Form(&quot;Description&quot;&amp;i&amp;&quot;&quot;)
	rs(&quot;ImageName&quot;&amp;i&amp;&quot;&quot;) = File.FileName 
	'Response.Write File.Size &amp; &quot; - &quot; &amp; File.Name &amp; &quot; - &quot; &amp; File.FileName &amp; &quot;&lt;br&gt;&quot;
	i = i + 1 'Increment i
Next

'Post the form details and images to the users directory.
rs.Update 

On Error Resume Next
'Set Upload = Nothing
conn.Close
set rs = nothing
set conn = nothing
Session.Remove(&quot;folderPath&quot;)
'End If

%&gt;
&lt;!DOCTYPE html public &quot;-//W3C//DTD HTML 4.01 Transitional//EN&quot; &quot;http://www.w3.org/TR/html4/loose.dtd&quot;&gt;
&lt;HTML&gt;
&lt;HEAD&gt;
&lt;META http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=iso-8859-1&quot;&gt;
&lt;LINK rel=&quot;STYLESHEET&quot; href=&quot;class/all.css&quot; type=&quot;text/css&quot;&gt;
&lt;SCRIPT LANGUAGE=&quot;JavaScript&quot; TYPE=&quot;text/javascript&quot; src=&quot;scripts/preload.js&quot;&gt;&lt;/SCRIPT&gt;
&lt;SCRIPT LANGUAGE=&quot;JavaScript1.2&quot; SRC=&quot;scripts/HM_Loader.js&quot; TYPE=&quot;text/javascript&quot;&gt;&lt;/SCRIPT&gt;
&lt;script&gt;
function goBack(){
setTimeout('history.go(-1)', 4000);
}
&lt;/script&gt; 
&lt;!--#include file=&quot;inc/include.asp&quot;--&gt;
&lt;/HEAD&gt;
&lt;BODY bgcolor=&quot;#FFFFFF&quot; onLoad=&quot;&lt;%=loadStr%&gt;&quot;&gt;
	&lt;TABLE border=&quot;0&quot; cellpadding=&quot;10&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;&gt;
		&lt;TR&gt;
			&lt;TD&gt;	&lt;!--#include file=&quot;inc/menu.asp&quot;--&gt;
	&lt;TABLE cellspacing=&quot;10&quot; cellpadding=&quot;10&quot; border=&quot;0&quot; width=&quot;80%&quot; align=&quot;center&quot;&gt;
		&lt;TR&gt;
			&lt;TD&gt;	
			&lt;/TD&gt;
		&lt;/TR&gt;
		&lt;TR&gt;
			&lt;TD&gt;	&lt;% If loadStr &gt; &quot;&quot; Then
							Response.Write msgStr
						Else
							Response.Write &quot;Information loaded succesfully!&lt;p&gt; Click &lt;a href=&quot;&quot;myView.asp?uname=&quot;&amp;Upload.Form(&quot;UserName&quot;)&amp;&quot;&gt;here &lt;/a&gt; to view your ride.&quot;
						End If 'Call BuildMyRide(&quot;varSignin&quot;, Upload.Form(&quot;UserName&quot;))%&gt;
			&lt;/TD&gt;
		&lt;/TR&gt;
	&lt;/TABLE&gt;
&lt;/BODY&gt;
&lt;/HTML&gt;
----------------------------------------------------------
&lt;!DOCTYPE html public &quot;-//W3C//DTD HTML 4.0 Transitional//EN&quot;&gt;
&lt;HTML&gt;
&lt;HEAD&gt;
&lt;LINK rel=&quot;STYLESHEET&quot; href=&quot;class/all.css&quot; type=&quot;text/css&quot;&gt;
&lt;SCRIPT LANGUAGE=&quot;JavaScript&quot; TYPE=&quot;text/javascript&quot; src=&quot;scripts/preload.js&quot;&gt;&lt;/SCRIPT&gt;
&lt;SCRIPT LANGUAGE=&quot;JavaScript1.2&quot; SRC=&quot;scripts/HM_Loader.js&quot; TYPE=&quot;text/javascript&quot;&gt;&lt;/SCRIPT&gt;

&lt;/HEAD&gt;
&lt;BODY bgcolor=&quot;#FFFFFF&quot;&gt;
&lt;!--#include file=&quot;inc/menu.asp&quot;--&gt;
	&lt;TABLE cellspacing=&quot;10&quot; cellpadding=&quot;10&quot; border=&quot;0&quot; align=&quot;center&quot;&gt;
		&lt;TR&gt;
			&lt;TD&gt;	Submit your vehicle to our website, we would love to hear from you about your ride!&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;FONT color=&quot;red&quot;&gt;*&lt;/FONT&gt; Required
&lt;P&gt;
				&lt;TABLE border=&quot;0&quot; cellpadding=&quot;4&quot; cellspacing=&quot;0&quot; width=&quot;650&quot; align=&quot;center&quot;&gt;
					&lt;TR&gt;
						&lt;TD&gt;
							&lt;FORM action=&quot;submit_ride_test.asp&quot; method=&quot;post&quot; ENCTYPE=&quot;multipart/form-data&quot; name=&quot;ride1&quot; id=&quot;ride1&quot;&gt;
								&lt;TR&gt;
									&lt;TD&gt;	First Name: &lt;FONT color=&quot;red&quot;&gt;*&lt;/FONT&gt;
									&lt;/TD&gt;
									&lt;TD&gt;										
										&lt;INPUT type=&quot;text&quot; name=&quot;FirstName&quot;&gt;
									&lt;/TD&gt;
									&lt;TD width=&quot;78&quot;&gt;	Last Name: &lt;FONT color=&quot;red&quot;&gt;*&lt;/FONT&gt;
									&lt;/TD&gt;
									&lt;TD&gt;										
										&lt;INPUT type=&quot;text&quot; name=&quot;LastName&quot;&gt;
									&lt;/TD&gt;
								&lt;/TR&gt;
								&lt;TR&gt;
									&lt;TD&gt;	Make: &lt;FONT color=&quot;red&quot;&gt;*&lt;/FONT&gt;
									&lt;/TD&gt;
									&lt;TD&gt;										
										&lt;INPUT type=&quot;text&quot; name=&quot;Make&quot;&gt;
									&lt;/TD&gt;
									&lt;TD&gt;	Model: &lt;FONT color=&quot;red&quot;&gt;*&lt;/FONT&gt;
									&lt;/TD&gt;
									&lt;TD&gt;										
										&lt;INPUT type=&quot;text&quot; name=&quot;Model&quot;&gt;
									&lt;/TD&gt;
								&lt;/TR&gt;
								&lt;TR&gt;
									&lt;TD width=&quot;205&quot; valign=&quot;top&quot;&gt;	Vehicle Features: &lt;FONT color=&quot;red&quot;&gt;*&lt;/FONT&gt;&lt;BR&gt;
									&lt;/TD&gt;
									&lt;TD colspan=&quot;3&quot;&gt;
										&lt;TEXTAREA cols=&quot;82&quot; rows=&quot;6&quot; name=&quot;features&quot; id=&quot;features&quot; onClick=&quot;document.ride1.features.value='';&quot; class=&quot;TextField&quot;&gt;Enter such things as engine, trans, mods, paint and body, interior...&amp;nbsp;&amp;nbsp;Anything you want to share about your ride. 

[click to clear]&lt;/TEXTAREA&gt;
									&lt;/TD&gt;
								&lt;/TR&gt;
								&lt;TR&gt;
									&lt;TD colspan=&quot;4&quot;&gt;	You can upload as many as 3 images of your car, the images will be resized to 800x600 automatically and are limited to 500k in size.&amp;nbsp;&amp;nbsp;Accepted image types include .jpg, .gif and .bmp
									&lt;/TD&gt;
						&lt;/TD&gt;
					&lt;/TR&gt;
					&lt;TR&gt;
						&lt;TD&gt;	Image 1:
						&lt;/TD&gt;
						&lt;TD&gt;							
							&lt;INPUT TYPE=FILE NAME=&quot;FILE1&quot;&gt;
						&lt;/TD&gt;
						&lt;TD&gt;	Description:
						&lt;/TD&gt;
						&lt;TD&gt;							
							&lt;INPUT TYPE=TEXT NAME=&quot;DESCR1&quot;&gt;
						&lt;/TD&gt;
					&lt;/TR&gt;
					&lt;TR&gt;
						&lt;TD&gt;	Image 2:
						&lt;/TD&gt;
						&lt;TD&gt;							
							&lt;INPUT TYPE=FILE NAME=&quot;FILE2&quot;&gt;
						&lt;/TD&gt;
						&lt;TD&gt;	Description:
						&lt;/TD&gt;
						&lt;TD&gt;							
							&lt;INPUT TYPE=TEXT NAME=&quot;DESCR2&quot;&gt;
						&lt;/TD&gt;
					&lt;/TR&gt;
					&lt;TR&gt;
						&lt;TD&gt;	Image 3:
						&lt;/TD&gt;
						&lt;TD&gt;							
							&lt;INPUT TYPE=FILE NAME=&quot;FILE3&quot;&gt;
						&lt;/TD&gt;
						&lt;TD&gt;	Description:
						&lt;/TD&gt;
						&lt;TD&gt;							
							&lt;INPUT TYPE=TEXT NAME=&quot;DESCR3&quot;&gt;
						&lt;/TD&gt;
					&lt;/TR&gt;
					&lt;TR&gt;
						&lt;TD&gt;							
							&lt;INPUT TYPE=SUBMIT VALUE=&quot;Upload!&quot;&gt;
						&lt;/TD&gt;
					&lt;/TR&gt;
				&lt;/TABLE&gt;
&lt;/FORM&gt;
			&lt;/TD&gt;
		&lt;/TR&gt;
	&lt;/TABLE&gt;
&lt;/BODY&gt;
&lt;/HTML&gt;
</code></pre>
</div>

<div>
Mgfranz - 
 
Thanks for taking time to reply. &nbsp;However I get an error message when trying to follow you sample. &nbsp; 
 
Set Upload = Server.CreateObject(&quot;Persits.Upload&quot;) 
_____________________________________________________ 
Server object error 'ASP 0177 : 800401f3' 
 
Server.CreateObject Failed 
</div>

<div>
Kecha - 
 
I'm not sure where to ever start. &nbsp; 
 
As I stated, the Insert and upload work fine indepenet of each other. &nbsp;But when I try to make them play together they hate it.
</div>

<div>
With my code you have to download and install Persits ASPUpload, <a href="http://www.aspupload.com/download.html" rel="ugc">http://www.aspupload.com/download.html</a>&nbsp; Check with your hosting server to see what Upload components they have installed since it's possible that they may or may not have this component installed.
</div>

<div>
Unfortunately I've been trying to find a &quot;free&quot; solution. &nbsp;Do you have any other suggestions?
</div>

<div>
Yes I use Dreamweaver. &nbsp; 
 
Now on the submit of the page, I would then make a refernece to a new page which would have the behavior of the submit_ride_test.asp example you provided. 
 
I would omit this piece of your code and use the piece from the Set Upload = Server.CreateObject(&quot;Persits.Upload&quot;) and submit to the free asp upload page? 

</div>

<div>
I've tried to add the insert statement when the file is being saved but I get the error message that 
 
I get the following error - however, this the correct spelling of the database and path. &nbsp;I have given full persmissions to users on the folder and can write to the database fine elsewhere. 
 
Microsoft JET Database Engine error '80004005' 
 
Could not find file 'C:\Inetpub\wwwroot\FacilityConditionTracking\FacilitiesPlan.accdb'. 
 
/FacilityConditionTracking/uploadTester4.asp, line 94 

<pre><code class="code-10 nolinks" id="code-1054249">function SaveFiles
 Dim Upload, fileName, fileSize, ks, i, fileKey

 Set Upload = New FreeASPUpload
 Upload.Save(uploadsDirVar)

 ' If something fails inside the script, but the exception is handled
 If Err.Number&lt;&gt;0 then Exit function

 SaveFiles = &quot;&quot;
 ks = Upload.UploadedFiles.keys
 if (UBound(ks) &lt;&gt; -1) then
 response.write &quot;&lt;h3&gt;Upload Success!&lt;/h3&gt;&quot;
 SaveFiles = &quot;&lt;B&gt;You have successfully uploaded:&lt;/B&gt; &quot;
 
 Dim CurrentTime
 CurrentTime = NOW()
 Dim cn,sql,theFile,sFileTitle
 Set cn = Server.CreateObject(&quot;ADODB.Connection&quot;)
 cn.Open &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&quot;&amp; Server.MapPath(&quot;FacilitiesPlan.accdb&quot;) &amp;&quot;;Persist Security Info=False&quot;
 

 for each fileKey in Upload.UploadedFiles.keys
 
 SaveFiles = SaveFiles &amp; Upload.UploadedFiles(fileKey).FileName &amp; &quot; &lt;br&gt;&quot;
 ' SaveFiles = SaveFiles &amp; &quot;&lt;br&gt;You can view this document here: &quot; 
 'SaveFiles = SaveFiles &amp; &quot;http://www.mywebsite.co.uk/tempUploads/&quot; &amp; Upload.UploadedFiles(fileKey).FileName
 
 
 theFile = Upload.UploadedFiles(fileKey).FileName ' the filename of the actual file
 sFileTitle = Upload.Form(Upload.UploadedFiles(fileKey) &amp; &quot;_name&quot;) ' what the user entered in the filename field
 
 'insert query

				
 sql = &quot;Insert into NotedIssues([attachment],[funding,file_name) values (&quot; _
 &amp; &quot;'&quot; &amp; attach1 &amp; &quot;', &quot; _
 &amp; &quot;'&quot; &amp; funding &amp; &quot;)&quot;
 
 cn.Execute(sql)
 
 next
 
 'Now that we have displayed the table data lets close the connection
 cn.Close
 Set cn = nothing
 
 else
 SaveFiles = &quot;The file name specified in the upload form does not correspond to a valid file in the system.&quot;
 end if
 'SaveFiles = SaveFiles &amp; &quot;&lt;br&gt;Enter a number = &quot; &amp; Upload.Form(&quot;enter_a_number&quot;) &amp; &quot;&lt;br&gt;&quot;
 'SaveFiles = SaveFiles &amp; &quot;Checkbox values = &quot; &amp; Upload.Form(&quot;checkbox_values&quot;) &amp; &quot;&lt;br&gt;&quot;
end function
</code></pre>
</div>

<div>
Well, first of all, that is not the entire code for the page in question since there is no line 94 in your code. &nbsp;Second of all, in your code, you have the line; 
 
&quot;Server.MapPath(&quot;FacilitiesPlan.accdb&quot;)&quot; 
 
This translates the connection string to locate the database file in the root folder, basically it is looking for it in the path; 
 
&quot;<a href="http://www.yoursite.com/directory" rel="ugc">http://www.yoursite.com/directory</a>&nbsp;OfScript.asp/FacilitiesPlan.accdb&quot; 
 
Is that where you have the database? &nbsp;In the same directory of the script? &nbsp;You need to be specific when using Server.MapPath(), Read here for more, <a href="http://www.4guysfromrolla.com/webtech/121799-1.shtml" rel="ugc">http://www.4guysfromrolla.com/webtech/121799-1.shtml</a>
</div>

<div>
Yes for development purposes I placed everything in the root foolder. 
 
The error on line 94 is line 20 above. 

<pre><code class="code-1 nolinks" id="code-1054522">cn.Open &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&quot;&amp; Server.MapPath(&quot;FacilitiesPlan.accdb&quot;) &amp;&quot;;Persist Security Info=False&quot;
</code></pre>
</div>

<div>
I've created a new database folder and get the same error.
</div>

<div>
There are hundreds of reasons why you would be getting an '80004005' error, most of them have to do with permissions. &nbsp;The file and the folder need to have IUSER permissions opened up. &nbsp;This might help. &nbsp;<a href="http://imar.spaanjaars.com/263/how-do-i-fix-asp-80004005-errors" rel="ugc">http://imar.spaanjaars.com/263/how-do-i-fix-asp-80004005-errors</a> 

</div>

<div>
OK, I've follolwed the instructions and receive a different error. 
 
Microsoft JET Database Engine error '80040e4d' 
 
Cannot start your application. The workgroup information file is missing or opened exclusively by another user. 
 
/FacilityConditionTracking/uploadTester3.asp, line 101 
 
MyConnection.Open MyConnectionString 

<pre><code class="code-10 nolinks" id="code-1066270">Dim MyConnection
				Dim MyConnectionString
				Dim MySQLStatement
				
				MyConnectionString = &quot;Provider=Microsoft.Jet.OLEDB.4.0;&quot; &amp;_
				&quot;Data Source=C:\Inetpub\wwwroot\FacilityConditionTracking\Database; User ID=bftasks;Password=JumboDog&quot; 
				MySQLStatement = &quot;INSERT INTO NotedIssues (AiMWO) Values ('166777')&quot;
				
				Set MyConnection = Server.CreateObject(&quot;ADODB.Connection&quot;)
				MyConnection.Open MyConnectionString
				MyConnection.Execute(MySQLStatement)
				MyConnection.Close()
				
				Response.Write (&quot;Record inserted&quot;)
				Set MyConnection = Nothing
</code></pre>
</div>

<div>
It's not a good idea to post usernames and passwords to an open forum... 
 
That aside, this is still a security issue, try this link for more. &nbsp;<a href="https://www.experts-exchange.com/questions/22996674/Microsoft-JET-Database-Engine-error-'80040e4d'.html" rel="ugc">https://www.experts-exchange.com/questions/22996674/Microsoft-JET-Database-Engine-error-'80040e4d'.html</a>
</div>

<div>
those were bogus id's and passwords. &nbsp;Thanks for pointing that out. &nbsp; 
 
I converted the database to an Access 2003 database and I'm able to upload the file and insert a record. &nbsp; 
 
I'd like to keep it an Access 2007 database so i guess I'll need to research the connection string format. 
 
Here's what I used for 2003 databse connection and it worked. 

<pre><code class="code-10 nolinks" id="code-1067372">Dim MyConnection
				Dim MyConnectionString
				Dim MySQLStatement
				
				MyConnectionString = &quot;Provider=Microsoft.Jet.OLEDB.4.0;&quot; &amp;_
				&quot;Data Source=C:\Inetpub\wwwroot\FacilityConditionTracking\Database\FaciltiesPlan.mdb;&quot; &amp;_
				&quot;User Id=;Password=&quot; 
		

Set MyConnection = Server.CreateObject(&quot;ADODB.Connection&quot;)
				MyConnection.Open MyConnectionString
				MyConnection.Execute(MySQLStatement)
				MyConnection.Close()
				
				Response.Write (&quot;Record inserted&quot;)
				Set MyConnection = Nothing
</code></pre>
</div>

<div>
Do a Response.Write on the Insert string before running the Execute, chances are there is an issue with a parameter being a string and not a integer or something like that. 
 
I have never used a connection string with the .accdb database, only .mdb or SQL databases so I can't help with why the 2007 database won't work, unless it wasn't properly configured somehow.
</div>

<div>
Here's what I get............ 
 
Astronomy BuildingAdministration008.jpgINSERT INTO NotedIssues (FACILITY, shop2, Location, Level, Facility_Component, Employee_Adding_Issue, Type_of_Equipment, Issue, Required_Correction, Additional_Information, Attachment, Index_Number, AIM_WO, Funding_Approved, Correction_Priority, Correction_Estimated_Start, Estimate_Correction_Cost, Correction_Estimate_Complete, Funding2) VALUES (Astronomy Building','Administration','','',' ',' Amezquita, Esther F.','','', '',' ','008.jpg','Astronomy Building','','','Service Affecting','','','Astronomy Building','BRR) 
 
Microsoft Office Access Database Engine error '80040e14' 
 
Syntax error in INSERT INTO statement. 
</div>

<div>
I changed the name Level and now get a new error. &nbsp;I have been researching Google. &nbsp;I can appreicate your patience with &quot;newbie&quot; stuff. &nbsp; 
 
Microsoft Office Access Database Engine error '80040e14' 
 
Syntax error (missing operator) in query expression ''Cervantes Village, Bldg A (Children's Village'. 
 
This is the first field on the insert statement &quot;Facility&quot;.
</div>

<div>
Your error is in front of you. &nbsp;Children's Village' &nbsp;The single quote will kill the SQL. 
 
You are asking a lot for 125 points my friend... &nbsp;Almost all of your errors can be fixed with a simple Google search on the error number and message.
</div>

<div>
I apologize as I said I'm a newbie to this forum also. &nbsp;I've increased the number of points to 500. &nbsp; I realized that I will need to clean up some data. 
 
NSERT INTO NotedIssues (Facility, Shop, Location, NotLevel, FacilityComponent, EmployeeAddingIssue, TypeofEquipment, Issue, RequiredCorrection, AdditionalInformation, Attachment, IndexNumber, AIMWO, FundingApproved, CorrectionPriority, CorrectionEstimatedStart, EstimateCorrectionCost, CorrectionEstimatedComplete, Funding) VALUES (Beef Office','Administration','','',' ',' BJ Maestas','','', '',' ','009.jpg','','','','Service Affecting','','','','BRR) 
 
Microsoft Office Access Database Engine error '80040e14' 
 
Syntax error (missing operator) in query expression 'Beef Office','Administration','','',' ',' BJ Maestas','','', '',' ','009.jpg','','','','Service Affecting','','','','BRR'. 

<pre><code class="code-1 nolinks" id="code-1071008">MySQLStatement = &quot;INSERT INTO NotedIssues (Facility, Shop, Location, NotLevel, FacilityComponent, EmployeeAddingIssue, TypeofEquipment, Issue, RequiredCorrection, AdditionalInformation, Attachment, IndexNumber, AIMWO, FundingApproved, CorrectionPriority, CorrectionEstimatedStart, EstimateCorrectionCost, CorrectionEstimatedComplete, Funding) VALUES (&quot;&amp; FACILITY &amp;&quot;','&quot;&amp; shop2 &amp; &quot;','&quot;&amp; Location &amp;&quot;','&quot;&amp; NotLevel&amp;&quot;',' &quot;&amp;	Facility_Component&amp;&quot;',' &quot;&amp; Employee_Adding_Issue&amp;&quot;','&quot;&amp; Type_of_Equipment&amp;&quot;','&quot;&amp; Issue&amp;&quot;', '&quot;&amp;Required_Correction&amp;&quot;',' &quot;&amp; Additional_Information&amp;&quot;','&quot;&amp; Attachment &amp;&quot;','&quot;&amp; Index_Number&amp;&quot;','&quot;&amp; AIM_WO&amp;&quot;','&quot;&amp; Funding_Approved&amp;&quot;','&quot;&amp; Correction_Priority&amp;&quot;','&quot;&amp; Correction_Estimated_Start&amp;&quot;','&quot;&amp; Estimate_Correction_Cost&amp;&quot;','&quot;&amp; Correction_Estimated_Complete&amp;&quot;','&quot;&amp; Funding2&amp;&quot;)&quot;
</code></pre>
</div>

<div>
Can you please do some reading before posting errors like this? &nbsp;Go through a few pages at Google and correct whatever issues you might be having with the SQL. &nbsp;This error is a common error and usually means that you are either trying to pass data that the field does not like or the field is required to have a certain type of data and is is not getting it. &nbsp;Field types like Int and Date require proper formatting and delimiting. &nbsp;If you use quotes around a integer for example you will get this error. &nbsp;If the field is set to Int() and you try to pass it a string you will get an error.
</div>

<div>
Your missing quotes; &nbsp;Also watch for spaces in the insert values, especially at the beginning of the value. 
 
VALUES ('Beef Office','Administration','','','','BJ Maestas','','', '','','009.jpg','','','','Service Affecting','','','','BRR')
</div>

<div>
Well I'm getting closer. I'm able to upload a file and insert a record into the database. &nbsp;However, it seems that all fields are being required. &nbsp; 
 
I will &quot;GOOGLE&quot; a solution, but if you know one, pleae let me know. &nbsp;
</div>

<div>
You should either sent a &quot;&nbsp;&quot; value to the database, or correct the database itself to not require data on the fields. &nbsp;Or at the minimum, set a default value on the fields inside the database.
</div>

<div>
Now I still have a problem where I can’t insert empty/blank values into the database. &nbsp;What am I doing wrong? &nbsp;Everything works if I populate all my fields with data on the form. &nbsp;I’ve already set the fields on the database to not be required. &nbsp;It also works if I put an initial value on the form but it doesn't like &quot;&quot;&nbsp;so I tried putting in null and it save the text as null. 
 
I feel so close but so far away. &nbsp; 
 

<pre><code class="code-10 nolinks" id="code-1079378">Dim FACILITY, shop2, Location, NotLevel, Facility_Component, Employee_Adding_Issue, Type_of_Equipment, Issue, Required_Correction, Additional_Information, Attachment, Index_Number, AIM_WO, Funding_Approved, Correction_Priority, Correction_Estimated_Start, Estimate_Correction_Cost, Correction_Estimate_Complete, Funding2
	
	

				
				FACILITY = Upload.Form(&quot;Facility&quot;) 
				response.write(Facility)
				shop2 = Upload.Form(&quot;shop2&quot;) 
				response.write(shop2)
				Location = Upload.Form(&quot;Location&quot;)
				response.write(Location)
				NotLevel = Upload.Form(&quot;NotLevel&quot;) 
				response.write(NotLevel)
				Facility_Component = Upload.Form(&quot;Facility_Component&quot;) 
				response.write(Facility_Component)
				Employee_Adding_Issue = Upload.Form(&quot;Employee_Adding_Issue&quot;) 
				response.write(Employee_Adding_Issue)
				Type_of_Equipment = Upload.Form(&quot;Type_of_Equipment&quot;) 
				response.write(Type_of_Equipment)
				Issue = Upload.Form(&quot;Issue&quot;) 
				response.write(Issue)
				Required_Correction = Upload.Form(&quot;Required_Correction&quot;) 
				response.write(Required_Correction)
				Additional_Information = Upload.Form(&quot;Additional_Information&quot;) 
				response.write(Additional_Information)
				Attachment = Upload.Form(&quot;Attachment&quot;) 
				response.write(Attachment)
				Index_Number = Upload.Form(&quot;Index_Number&quot;) 
				response.write(Index_Number)
				AIM_WO = Upload.Form(&quot;AIM_WO&quot;) 
				response.write(AIM_WO)
				Funding_Approved = Upload.Form(&quot;Funding_Approved&quot;) 
				response.write(Funding_Approved)
				Correction_Priority = Upload.Form(&quot;Correction_Priority&quot;) 
				response.write(Correction_Priority)
				Correction_Estimated_Start = Upload.Form(&quot;Correction_Estimated_Start&quot;) 
				response.write(Correcdtion_Estimated_Start)
				Estimate_Correction_Cost = Upload.Form(&quot;Estimate_Correction_Cost&quot;) 
				response.write(Estimate_Correction_Cost)
				Correction_Estimated_Complete= Upload.Form(&quot;Correction_Estimated_Complete&quot;) 
				response.write(Correction_Estimated_Complete)
				Funding2= Upload.Form(&quot;Funding2&quot;) 
				response.write(Funding2)

MySQLStatement = &quot;INSERT INTO NotedIssues (Facility, Shop, Location, NotLevel, FacilityComponent, EmployeeAddingIssue, TypeofEquipment, Issue, RequiredCorrection, AdditionalInformation, Attachment, IndexNumber, AIMWO, FundingApproved, CorrectionPriority, CorrectionEstimatedStart, EstimateCorrectionCost, CorrectionEstimatedComplete, Funding) VALUES ('&quot;&amp;FACILITY&amp;&quot;','&quot;&amp;shop2&amp;&quot;','&quot;&amp;Location&amp;&quot;','&quot;&amp;NotLevel&amp;&quot;','&quot;&amp;Facility_Component&amp;&quot;','&quot;&amp;Employee_Adding_Issue&amp;&quot;','&quot;&amp;Type_of_Equipment&amp;&quot;','&quot;&amp;Issue&amp;&quot;', '&quot;&amp;Required_Correction&amp;&quot;','&quot;&amp;Additional_Information&amp;&quot;','&quot;&amp;Attachment&amp;&quot;','&quot;&amp;Index_Number&amp;&quot;','&quot;&amp;AIM_WO&amp;&quot;',&quot;&amp;Funding_Approved&amp;&quot;,'&quot;&amp;Correction_Priority&amp;&quot;',#&quot;&amp;Correction_Estimated_Start&amp;&quot;#,'&quot;&amp;Estimate_Correction_Cost&amp;&quot;',#&quot;&amp;Correction_Estimated_Complete&amp;&quot;#,'&quot;&amp;Funding2&amp;&quot;')&quot;



		Response.Write (MySQLStatement)
			
			
	Set MyConnection = Server.CreateObject(&quot;ADODB.Connection&quot;)
				MyConnection.Open MyConnectionString
				MyConnection.Execute(MySQLStatement)
				MyConnection.Close()
				
				Response.Write (&quot;Record inserted&quot;)
				Set MyConnection = Nothing
</code></pre>
</div>

<div>
Where are you getting the error? &nbsp;On the Execute line? &nbsp;What is the error? &nbsp;
</div>

<div>
Yes on the execute line 
 
Microsoft Office Access Database Engine error '80040e07' 
 
Syntax error in date in query expression '#'. 
 
/FacilityConditionTracking/bj4insert.asp, line 618 
</div>

<div>
I can save the record as long as I select the checkbox and enter a date in the two date fields. &nbsp;The rest of the fields are fine being empty. 
 
I have read numerous articles about not using single quotes around variables that are tied to checkboxes and dates. &nbsp;This works fine as long as there is a value. &nbsp;But if it is empty/blank then I can't hit the database.
</div>

<div>
Checkbox values are boolean type data, you need to verify that the value being passed is either a 1 or a 0, true or false. &nbsp;Boolean data type don't require single quotes like string/text data type also. &nbsp; As for the date field, if the date is not passed to the .asp correctly, you will have to format the date so that the db will accept it. &nbsp;What is the field type in the database for both the checkbox and date data? 
 
Do a response.write on the MySQLStatement and post the results with the checkbox and date populated and without.
</div>

<div>
I was troubleshooting and created a response.write statement on all the fields..... 
 
Results without checkbox and date (with error message) 
 
Fulton Athletic Center (Stadium Annex)AdministrationAmezquita, Esther F.000.jpgService AffectingBRR 
 
INSERT INTO NotedIssues (Facility, Shop, Location, NotLevel, FacilityComponent, EmployeeAddingIssue, TypeofEquipment, Issue, RequiredCorrection, AdditionalInformation, Attachment, IndexNumber, AIMWO, FundingApproved, CorrectionPriority, CorrectionEstimatedStart, EstimateCorrectionCost, CorrectionEstimatedComplete, Funding) VALUES ('Fulton Athletic Center (Stadium Annex)','Administration','','','','Amezquita, Esther F.','','', '','','000.jpg','','',,'Service Affecting',##,'',##,'BRR') 
 
Microsoft Office Access Database Engine error '80040e14' 
 
Syntax error in INSERT INTO statement. 
 
/FacilityConditionTracking/bj4insert.asp, line 625 
 
 
Checkbox checked and dates entered 
 
Fulton Athletic Center (Stadium Annex)AdministrationAmezquita, Esther F.000.jpg1Service Affecting9/1/109/2/10BRR 
 
INSERT INTO NotedIssues (Facility, Shop, Location, NotLevel, FacilityComponent, EmployeeAddingIssue, TypeofEquipment, Issue, RequiredCorrection, AdditionalInformation, Attachment, IndexNumber, AIMWO, FundingApproved, CorrectionPriority, CorrectionEstimatedStart, EstimateCorrectionCost, CorrectionEstimatedComplete, Funding) VALUES ('Fulton Athletic Center (Stadium Annex)','Administration','','','','Amezquita, Esther F.','','', '','','000.jpg','','',1,'Service Affecting',#9/1/10#,'',#9/2/10#,'BRR')Record insertedFiles uploaded: 000.jpg (202962B) 
</div>

<div>
Adding the if statement to set the value to &quot;0&quot; worked. &nbsp; 
 
Moving on to the date. 
 
THe field in the database is Date/Time: Format=Short Date: &nbsp;Required=No: Indexed=No: IME Mode = No Control: IME Sentence Mode=None: Text Align = General : Show Date PIcker = Never 
 
I don't have the option to allow null on this filed like the other fields. &nbsp;The two date fields are for estimated start date and the actual completion date. &nbsp;The user will enter the completion date when the item has been completed and not at the time of initial data entry. &nbsp; 
 
I don't think putting in today's date would work for the completion date.
</div>

<div>
Thank you so much for you help and patience with a newbie.
</div>

<div>
<div class="content wysiwyg-content">
I've seen similiar questions throughout the web but I'm still struggling with this one. 
 
I have a form where a user supplies information and then can brows to for a file to upload if needed. 
 
I'm using CS4 and ASP with access db (users choice). &nbsp;I have successfully created the form which stores the path/filename in a text field in the database on the insert record server behavior. &nbsp;However, i have not been successful at uploading the file to the server first. &nbsp;I would like the user to only have to browse for the file once and have the submit button upload the file and insert the record if possible. 
 
I have read and tried using Free ASP Upload. &nbsp;I can get the upload to work fine. &nbsp;But the upload and insert record are not working togther. &nbsp; 
 
Can someone help me get these two actions done with one Submit Button please?
</div>
</div>

I've seen similiar questions throughout the web but I'm still struggling with this one.

I have a form where a user supplies information and then can brows to for a file to upload if needed.

I'm using CS4 and ASP with access db (users choice).  I have successfully created the form which stores the path/filename in a text field in the database on the insert record server behavior.  However, i have not been successful at uploading the file to the server first.  I would like the user to only have to browse for the file once and have the submit button upload the file and insert the record if possible. 

I have read and tried using Free ASP Upload.  I can get the upload to work fine.  But the upload and insert record are not working togther.  

Can someone help me get these two actions done with one Submit Button please?

Upload File and Insert Record into Database  - 2 Actions with 1 Button

Adobe Dreamweaver is a web development tool featuring both WYSIWYG and code editors that allow the user to quickly and easily build websites in a wide variety of languages, including ASP, ASP.NET, ColdFusion and PHP. It also offers support for CSS and JavaScript.

Adobe Dreamweaver

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.