Hi Emma,

We have a mixture here of power users that use an mdb with linked tables. It works well for them and in some cases, as the repetitive tasks began to take too long on the 'client' side, requests came for transplanting the queries with stored procedures / views (sql 2000) on the server side. The mdb solution for our power users provides a 'development' area for them that really separates them from the production realm. Most will pull a create table query and work locally until they have the desired results. Depending on the size of the tables you could offer some guidelines for use to help them not hit some unnecessary walls. Good luck, been there!

Jody