• Good question and one I dont know enough to answer. One way would be to try it and see:-) Probably worth finding an Access newsgroup, see if they can offer some help. If your solution is working dont know that I'd do much changing, though if you get to the point where scaling is an issue putting mdb on each machine should help a lot.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/