Pretty much ya...

What do you want to do next?

Check out the adox refferences in access.  That'll get you started.

You can also access the system objects to find the list of tables of Access (check the options to show...

Yes.

This is one rare case where using EM to do the job will be faster... and error proof (developping time wise).

SUM(CASE WHEN dob_age ­­>= 80 THEN 1 ELSE 0 END) * WhateverHere AS X80

That's how I'd do it server side... maybe that can be applied is SSRS :

SUM(CASE WHEN dob_age ­­>= 80 THEN 1 ELSE 0 END) AS X80

SUM(CASE WHEN dob_age ­­<...

Here's one question.  Why are you doing this server side?  I know you can find some trick or tweak, but this seems to be a problem more suited for excel...

In my case that NN table had a key about an access object.  From that table, I was drilling down all the way from Form to the form's object's properties.  The...

Sounds more like you need bi-directional replication.

I'm saying that without having done anything in replication, but it think it's worth a look for you.

Can't wait to see what others have to say about this one.

I think you're alright in this case. 

I've used the identity option in a few cases.  IIRC, it was...

Wasn't it that once said that it's better to ask for forgiveness than to ask for permissions (sometimes).

Good point Steve.

But there are advantages when consulting for a small shop .

Sure, run at 6 AM

First line of code :

WAITFOR DELAY 02:00:00

 .

I'd do that if reasoning with the person doesn't work.

What's the full reasoning behind this?

Triggers are a great tool when used to do the right job.  I'm not too sure in this case, but then again I don't have...

openquery / openrowset will offer 1 more option (one of them requires the link, but I forgot which one).

The other option is to use ssis or whatever else to get...

Thanks for the info.

Now let's see how I can do this in 2 weeks .