is it possible to have more than one user in ms access?

Answer 1

Two possibilities:
1. You create a .mdb file, and open it using Access. It is then still possible for another to open it, but as a read-only copy. More than 2 users are not allowed in this case.
2. You use MS Access to create a .mdb file, and then use some other application (different from Access) to query your database using the Microsoft Jet Driver for an ADO or a DAO connection. Then there is still a limitation on the number of parallell users, but it is much higher, and they normally would all have read-write access to it (except when the one who wrote the software forbade it). Example: you write your own Web site and use ASP 3.0 to write a guestbook, and store everything the people wrote in an Access based database. Then it is possible for many people to have your web page open at the same time and write something into the guestbook, and it will be saved to the database (almost) simultaneously.

Answer 2

If you mean accessing a database on the network simultaneously, then yes. Although I don't know all the specifics concerning what happens if two users attempt to update the same record simultaneously. There is a way to set it up so that tables and records will not conflict. I think it will take a Visual Basic guru to help you out there.

Answer 3

yes, it is possible, through a shared network resource. although it's not worth it, you'll have concurrency probs, a whole bunch of em if you have more than 5, give or take, users. Start thinking about upgrading the data to sql server, that way you can use the already programmed access ui to store it to sql server and have a real application on your hands.