Rob- I like this example. It will work for our business because we don't take long holidays

Thanks, Matt

I am using a System DSN for attached tables and SQL PassThru Queries. There is not an option when creating or modifying the WSID or AppID from the Access 2000...

Good article. Any ideas on doing something similar with Access 2000? I have a mdb that is shared by many people.