Hi,
I have designed a database which is required to be used by more than 20 users simultaneously at a time. How do I make the userform of the database to update and add records simulateously by concurrent users. The Database has stored DB names with which users will log into as a means of security, the database does not track network or environ usernames. The Database will be shared via a shared network drive.
How do I achieve this. Will the user get an error that another user is using the DB at the same time;i.e. one user has to close the DB for it to be used by another user?
Thanks in advance