The very existence of an 'insert row' option makes it difficult to suggest that this is 'wrong'

You are using tools that I have...

No problem. Regarding the syntax / access violation problem, can you post the SQL command that you issued?

OK - don't do it, you are right!! It will not fix anything, I was merely trying to help you troubleshoot exactly where the error was being generated. But that's...

In my mind, there is a logical separation between the function of the JOIN clause (joining tables together) and the WHERE clause (filtering the data that is returned). Shovelling everything...

I don't quite understand what you want. Can you post the SP, some sample data and desired results?

Try commenting out line 102 and replace it with

response.write("EXEC InsertNextPage @StoryID='" & submission.Fields("StoryID") & "', @SubscriberID='" & submission.Fields("SubscriberID") & "', @Content='" & Cleanse(submission.Fields("Content")) & "'")

This should write a T-SQL...

Please post the declarations and instantiation of the conn object.

I guess the good thing about using views is that they are always up-to-date. You can just grab the data out of their database whenever you want (subject to load...

If the data that is coming out of the examination system contains rubbish as a result of bad design, that should not be your problem. You will end up building...

This sounds like a reply - but to what message?

Great - I like stories with happy endings

Create a table that contains just numbers - 0, 1, 2, 3, ..., 1000 say.

Then do a CROSS JOIN to this table from your label data source, where newtable.num < number of...

Like this? I don't know SQLLite.

select datepart(dw, getdate())

You are correct in stating that the first piece of SQL identifies all the latest owners and their assets, but by performing a self join back to the orig table...

Not strange really. MS Access is a database, a development environment, an end-user environment  ... it tries to do pretty much everything.

SQL Server is a pure database environment - it...