Trouble Inserting Strings Into A Table

If you look at the lefthand side of you toolbar while in the QBE grid (the table-like thing), you'll see a button with a picture of a table in it and a down arrow next to it. Pressing the button will take you to a "table view" (execute the query and display the results). Pressing the down arrow will activate a dropdown list of options. You want to choose the little icon with "SQL" in it. This will bring you to a giant text box that you can type your query into. You can also make complex queries in the QBE grid and switch to SQL view to copy the query text to the clipboard and use it in your code.

Thanks for that, it was very helpful to be able to apply the query directly within Access.

It seems that, although it had no problem read the table with the 'Timestamp' field, it didn't like INSERT INTO with that field. I couldn't find anything on it, as I would have expected for a reserved word, but that is what was highlighted when I tried to apply the query in Access.

It is now working, thankyou for your help.

(If you could suggest something for this I would be grateful, but it doesn't matter if you can't: is there any way to put strings greater than 255 characters into the database?)

Use the memo data type