I hate Access, I hate it so good.

Currently I'm working on a vb6 project that is meant to insert the same sets of data into a database in access database and one in pervasive. Now, I was anticipating all sorts of trouble with the pervasive side of things (mainly because I've never used pervasive) but that worked beautifully. The code to insert the data into the access table, on the other hand, is ruthlessly being rejected due to a "Syntax Error". Oddly, if I type the EXACT SAME QUERY into the access query sql view, it works like a charm. Literally, once the query fails the string is outputted to a text box on the form, and then I copy and paste it over, and bam.

I've combed over 12 pages of google search results and gotten NOTHING. Nothing but morons who put vb variable names into their query instead of concatenating them and people with single quotes all over their data. You know, REAL syntax errors instead of imaginary ones.

This was one of my personal favourite:

Hi, im fairly new to asp and would like to write information to an access database.

I have tried websites that have scripts but the ones i have saw are fairly complicated.

All i have is a form for the user to input information and then i want it to write to a pasific table in microsoft access.

If anyone can share or tell me how to do this it would be very much appricated.

Many Thanks
Marc

I'm going to go stab myself in the eye with a pen now. Good day.