It seems to me that 'multiple failure' is a basic problem in all walks of life, not just database issues.

I missed the meeting because (perm any three)

I got up late

Lost...

A couple of comments and suggestions from a newbie.

4 million records isn't really that many so you should be able to get it to work just fine.

The sp seems to...

Wow - click on the error and it takes you there - FAB!

We need a 'handy tip of the day'!

This would have saved me hours by now.

I guess the trouble...

It may not be appropriate, but you can easily write to SQL Server 2005 from Access 2007, so you could 'push' the data from Access rather than 'pulling' from SQL...

I agree that formmating in the front end is the way to go if possible as far as the question is concerned.

On a more general note, however, there are other...