>>I may start a new project that shoudl at some point use SQL Server. I am wondering if it'd be best to use Local Views to handle the >>tables and then switch the Remote Views to more easily move over to SQL Server, when it is necessary. Any advice is welcome.

I would say go for an nTier setup and create business objects that load from a dataobject. that way you can change the back end to anything and only need to change the data layer. you can make you own or use something like MereMortals.

Gary.