Richard, I have been waiting for a LONG time for this lesson on SQL server databases!  Thank you so much!  

I have a question: Is it possible to set all this up and then share a version of the Access database with someone that does not have Access on their machine?  I know a few people that have MS Office but not the version with Access so I cannot share the front-end database with them.

Thanks again for all of this information and for everything you do!

Rob

---

Reply from Richard Rost:

You SHOULD be able to create an Access database, connect it to your SQL Server backend, and then package and deploy that database using the Access Runtime Edition which means they wouldn't need a purchased copy of Access - HOWEVER I haven't tried this myself, so this is just a theory. Let me know if it works.