Upload / download attachment

[denimknight]

Hi all,

new to the forum, and desperately seeking help. I've tried posting on asp forum but didn't get too much help there, I think this is more an access question (hopefully).
I'm using an Access 2007 database and I am putting it online and plan to access it using ASP. The problem is the database uses the attachment data type for storing images and CV's and I have no idea how to do it... I tried the following:

strSQL = "INSERT INTO participant (ni_number, first_name, last_name, date_of_birth, image_file) VALUES ('" & nin & "','" & firstname & "','" & lastname & "','" & dob & "'," & image_file & ");"
Conn.Execute(strSQL)

But this didn't work, it gave back a syntax error. I thought that it was way to easy to do it that... On the ASP forum I was sent to a link about uploading binary files, is this the only way to do it? Because the site I hit about uploading binary files was really complicated and hard to follow.

Hope someone can help.

Cheers

Alex

 

[denimknight]

Hi again,

I've just change a bit of the code so it looks like this now:

strSQL = "INSERT INTO participant (ni_number, first_name, last_name, date_of_birth, [image]) VALUES ('" & nin & "','" & firstname & "','" & lastname & "','" & dob & "','" & photo & "');"
Conn.Execute(strSQL)

and it is now giving the error:

Microsoft Office Access Database Engine error '80004005'
An INSERT INTO query cannot contain a multi-valued field.

Any ideas?