No contest really

Thanks for the reply.

I have a bit of time, so I will set up a couple of virtual dev servers and experiment. Sounds like log shipping may be the way...

Difficult to say without understanding the query you are running.

Timeout messages can be misleading, but maybe you could rule out a query timeout by increasing your query's ODBC timeout property...

Thanks Jerry.

I did run on a local drive but it was a slow external disk - all I had available at the time. I think allocating more than 1gb...

Well, I left it running when I went home last night. Just arrived this morning, and the backup is about half way through, after maybe 23 hours!

I knew the...

Thank you, that is reassuring. I will wait patiently for a few more hours then.

Much obliged,

Paul..

Its backing up locally from one hard drive to another. There is some other activity on the server but it is very light. I am only seeing about 1-3% cpu...

Given that HR people have no way to be certain that any information they find is genuine, I don't think they should take any action based upon what they find...

Absolutely, we are feeling ripped off on petrol prices in Britain. This week I had to pay £1.18 point something per litre for unleaded petrol.

By my rough maths this...

If I understood correctly, for a single query you could open it in design view in Access, click 'View', then 'SQL View'.

Copy the text and paste into notepad, then...

This article is bang on and definitely strikes a chord with me. I have used all these suggestions at various points in my career.

My favourite is "Come in to...

Weird! I've never noticed that happening before, maybe because I usually work with linked sql tables rather than Access tables. I guess you can just delete these automaticly created relationships...

I think that if Access spots fields with the same name in two tables it helpfully decides to join them for you. If your primary key fields are called the...

Interesting point comparing us with doctors. The article didn't mention 'Doctor at a party' syndrome though... In the same way that doctors who admit their profession at a social event...

If your 25 table names are fixed, then create a query in SQL view and

SELECT Count(*) AS MyRowCount

FROM [tablename];

to get the total number of records. Then insert a row...