"I am very new to using Access but have created a database that I would like to use at the office. There are approximately 10 people that need to use this database throughout the day (most likely less than 3 users at the same time) to generate reports, queries, and enter/edit records. The problem that I am having is that only one person can currently have the database open at a time. Some times we have a need to have a few people accessing the database simultaneously.
We are all using Access 2003 on a network with the database stored on a network drive that everyone (applicable) has access to. Is it possible to change a setting and allow multiple users in the database at the same time? If so, what are some of the risks and other settings or options that I should know about to help with this situation?"
Do you have any advice? Interested in solutions to the same problem? Visit our forum and join the discussion.