Thanks to all for your advice - it was a bit of a slog, but all sorted now.

Regards

Janet

Thanks, Susan that looks much more manageable.  Just to check - can I use the same constraint-name for every column I change? or do they each have their own name? ...

Thanks to both - sadly, this is a sorry tale of inheriting a complex and undocumented system, and I have only a fairly superficial experience of Access so far.  My problem...

Delayed thanks to David - I've been busy getting the new server into production. Your ref was very useful, I'll explore that site further ...

Over and out!

Interesting to see how many different role combinations there are. Just to add one more ...

I look after 4 production databases, plus a handful of backup and test systems...

Success!

Thanks again for your help, we've now got our 2 hrs down to 16 mins using the battery/cache/accelleration. This is excellent.

Couple of academic questions:

Does anyone know why Raid5 has...

Hi - back again

Thanks again for your thoughts. We've been checking out the RAID - new server has RAID5 but with no battery on the cache memory - able...

Thanks for suggestions

New server as follows:

Compaq ML370G3

1 x 2.4Ghz Xeon

2.5Gb RAM

Disks—RAID5 (hardware RAID) about 70 gb available

Running Win 2000 with SQL Server 7

Old server as follows:

x86 family 6 model 5...