Recent content by denimknight

Hi all, I'm looking to link tables on a local access database (either 2007 or 2010, not decided yet) to tables held on a website. Basically it will be a kind of stock control type of thing, where if someone places an order online the number in stock will be reduced by 1 and the local copy of...

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...

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...