I have been using Access Data Projects for several years now.  IMHO, it is about the fastest and most efficient method of doing client-server SQL Server applications that can scale...