I am very impressed with ADP. I agree that Access does have lots of great features and this looks like a great way to combine those features in an efficient way with SQL Server.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor