Wes, many thanks. Lightbulb switches on. All the previous examples were much to clever for me...

For anyone who is having similar difficulties this is what I did.

After detecting the first...

I am using Access 97 as the frontend so do not use ADP, I use a standard mdb file (actually an MDE for users)

The only tables I have in...

I don't think it would help you. It is very large and has lots and lots of very specific funtionanility. You are far better off working through the examples in...

I started off by linking an Access frontend to an SQL Server backend but found that performance while reasonable on our LAN was not very good on the WAN.

Ditched that...

ODBC Connection

It is unusual for our Oracle DBA's to allow any external access but they are under quite a bit of pressure to supply me with the data and a...

Thanks for the reply.

I guess the scenario I outlined was the worst case.

The best case would be that my colleagues allow me to query our Oracle database direct from...

Many thanks for the replies. I did manage to work it out using a dynamic query but the examples provided are likely to be much more efficient so I...

"your citrix costs will go through the roof "

I remember now when preparing the Capex that the backend hardware and software for the simple solution came to $17,000 but with...

Clay, many thanks, that was very helpful. It's starting to make sense now.

I ran some tests over a 1 minute period with a sample every second and then imported the result...

Mike, many thanks for your comments.

While monitoring I was using an SQL Passthru query which when switching from design to view I guess is the equivalent of a table.

If the...

Before deciding the current method I did test on one of our Citrix Servers. I found that response times generally were much faster using ADO with the front end on...

Just to be clear.

If Access calls a procedure which returns 1,000,000 rows. The Access form only displays the most recent 20 which might be all the user wants to see....

I am fairly new to SQL Server and originally struggled with the manual approach but now adopt the following approach which seems to work very well for me.

I have a...

Tony, that looks really good. Many thanks.

Stefan

JP, thanks for your detailed answer.

[Approach 1 : Go SQL Server all the way]

I could not get XP_SendMail to work so based on the advice on this site went the...