In the course of doing an upsizing project with Access 2003 to SQL Server 2000 I have seen lots of questions related to ADP's and upsizing. I think this could do with it's own forum. There seems to be more and more companies going down the upsizing route.

Actually, while there's lots of upsizing to SQL Server going on, ADP's are not that popular. MS has moved away from them, and now recommends MDB's with linked tables instead. If it's not too late, I'd recommend that route to you.

If you do need advice about .ADP's or upsizing, then please post in the sql server forum..I am sure someone in that forum will be able to help you.