Bob,
Point taken. I shouldn't expect applications developed in any system to be entirely portable. And no, the Access front end and original back end database were never developed with SQL Server in mind.
My frustration stems from not being able to come up with a workable solution to my...