I have over seven years developed a sophisticated, busness process oriented Access database, covering all aspects of operations for a customers business, from payroll to production. Some of the conversion requirements mentioned for an ADP+SQL Server are dauting. If I appreciate one additional contraint correctly (not mentioned in the article), I also cannot have a forms data field as a query parameter even in a stored query.
My question is this: if all Access clients are able to run on the server via Windows Terminal Services, is there any benefit to moving to the ADP+SQL Server model?
