I was pleasantly surprised when I just tried this.  Peeling away everything but the selects from Oracle I got:

The First select statement took 35 seconds and returned 3457 rows.

The Second...

Thanks to both of you.

The SQL is selecting data from several tables on the Oracle database, according to date and several other criteria - and updating properly indexed tables on the...

Apologies, I'm talking through the top of my head.  You can actually turn View Objects back on in the importing database.

Paul

Thanks for the reply.  This is a possibility, but it can be pretty limiting for some development. 

Surprisingly enough, I've just discovered that if you hide tables etc through the...

Yes, it's the speed which has impressed me.

Thanks, again Scott

Paul

Thanks, Judie

This is an interesting comment - which we will have to think through.  I can recognise the implications.

Paul

Hi Scott

The penny has eventually dropped - and it works, Fantastic.  And it's really impressive.

Many thanks for all your time and trouble.

Paul

Thanks, Perry

I'm getting data fatigue.  I am normally linking to an Oracle Server not SQL Server.

Thanks again

Paul

Thanks for the tip.  We are in the UK.

A possibility we are exploring is installing a Wavecom Modem kit and SMS text messaging software.  From what I have been told,...

Hi Scott

I tried the following code on the On Open event of the report and it returned a mismatch.  I guess I am in error here.  I have tried to...

Hi Scott

I'm pretty new to this so have been struggling to come to grips with what sounds a great solution.

I've created a Pass-Through query using Access query design view -...

Thanks, Raman

This is very helpful.  I'll pass it on to our systems people to have a look at.

Paul

Hi and thanks

I'll look into this.  We are looking into using Exchange for at least part of the process, maybe your suggestion will complete the job.

Thanks again

Paul

Hi

Thanks for the reply. 

If I understand you correctly, this means that when a student is registered we would not only have to ask for a mobile phone number,...

Thanks for your responses.

I read through BOL and have managed to 'Configure SQL XML Support in IIS' using IIS Virual Directory management for SQL Server.  Running both SQL Server and...