Database with Multiple USers

[stryder09]

I have a database that multiple users enter information into. I have it set up to shutdown after 15 minutes of inactivity, so that other users can enter info. Is there any way that I can have a pop-up come up when some one opens the database, telling them that another users is already in the database and to try again later?

I know that access does not like multiple people entering data at once and when typically only save one of the persons data.

[ranman256]

Access DOES let multi users enter data. You need a split database. Each user gets their own copy of the frontend on their pc or network folder , and the backend (data tables) goes on the server so all can see.
Any number of people can enter data that way.

[stryder09]

I do have different frontends for each user, but unfortunately the table gets locked when one person is already in it. So multiple people cannot enter data at the same time. This was why I had the database shutdown automatically when idle for 15 minutes. Thats why I would like to create a pop up that says that "Database is already in Use, please try again later."

[June7]

Record locking has 3 modes. http://office.microsoft.com/en-us/ac...001232785.aspx

There is also a Record Locking default property in the Access app Client Settings. New forms will adopt the setting.

I have multi-user db and multiple users can edit same table.

[ssanfu]

Is the dB being opened in Exclusive mode or Shared mode?

[stryder09]

Thanks guys for your answers.