It is that simple, unless I don't understand the question.

Do you have multiple triggers that insert in the same target table?

Can you post the code you're using with its problems?

Good idea... but make sure it's a column with a default if possible. Just to avoid data that's be reloaded from an even older version of the app.

Isn't there a collection for the queries in access just like for the forms and reports.

Like currentproject.allqueries

You could do a for each q in ... and recreate the queries on...

Isn't there anyway to just return the recordset without transforming to xml?

Xml is only a much more bloated version of the data and therefore takes more resources to transport.

You're right... first time I see this situation.

Always something else to learn .

on the first trigger :

CREATE TRIGGER...

FOR Insert

AS

SET NOCOUNT ON

Insert into dbo.Table2 (Col1, Col2, Coln) Select Col1, Col2, Coln from Inserted

GO

Repeat process for the next trigger. This will do...

You have to keep the whole date to easily solve this problem :

Select datediff(d, '2005/01/01 20:00.000', '2005/01/02 04:00.000') = 480 minutes (8 hours)

This is the easy way out. ...

So close yet so far :

select custid from dbo.Txusage

where UsageTime between '2005-06-14 11:59' and '2005-06-14 17:00' and Venueid in (5,12)

group by custid

having...

It's not hard

try

--fail

insert into SomeTable (SomeCol) values ('This fails : '')

--works

insert into SomeTable (SomeCol) values ('This works : ''')

Forgot to ask (really the last one )

Is it 10 consecutive records for the same name or can have different names?

To quote Joe celko :

"You guys need to stop thinking proceduraly and start thinking in sets".

And I'm still waiting for my own answer on this one. Not the...

Now if it's not a typing problem, I can't help you, otherwise there's always those typing teaching softwares .

You'd be the first to understand all this by himself.

Up to the challenge ?

Is it possible that the user doesn't have permission to run FileProperty (can't find any info about the minimum permission required)?

As I explained you'd need to replace all the (') with (''). Or you could create a stored proc and avoid the problem altogether. It would also shield...