I agree with you and considered using at the onset of the Project but because of the "buts/complications " for example the fact that you cant modify base table without affecting view definition and having to drop it to remove dependencies etc so the answer is NO I haven't used it .
also am trying to keep the Ms Access Migration Project am helping out with as simple as possible without introducing too much complication because I would leave it to the owners to manage and administer once complete and they dont have much SQL Server knowledge .
also am trying to keep the Ms Access Migration Project am helping out with as simple as possible without introducing too much complication because I would leave it to the owners to manage and administer once complete and they dont have much SQL Server knowledge .