Thanks Craig

We spent the day putting the client back to full Access, exactly where they were at midnight Saturday. So now I need to spend the rest of time trying to get to grips with a much better way to use SQL Server as a backend to my Access front end.

To answer your question - No! The Access FE was unchanged from when it had an Access Back End. No pass through queries, no views, no stored procedures, or anything apart from standard Access techniques, or so I thought.

I fear a big learning curve coming up but by putting the client back to where they were I have bought us a load of time!!

Cheers

Dave