>thanks. I didn't know about the split database function.
>
>Another question: What's the best layout for deploying Access applications in multiple locations? I put the data into a separate database to hopefully aid distribution of program updates. Is there a better, Access provided method?
>
>Thanks in advance.

That would be the split database wizard. It basically automates the separation of data and application (menus, forms, code, etc.) so that when you need to update the application db you don't have to tell everybody to log off.