Wwpp,
Since you are using XP Pro and allowing multiple users to access AC database, over the period of time expect some database problems.
It is related with database pointer issues. I do not want to go deep into database architecture and data structures and how it is interacting with Operating System. In my opinion XP Pro is not robust enough to handle multiple users accessing the database at the same time.
In my office I am using Windows 2003 server OS. In future, as the practice grows I can easily add multiple users and they will be able to access the AC database simultaneously (remotely). This is done to avoid any database corruption. You can still use XP Pro one user at a time. When database gets corrupted, to fix it is a monstrous job, been there done that.
The best solution is described by Bert in the above post.
Thanks.
Sachin
Sr Software Engineer
Lean Six Sigma Black Belt
