Multiple Users

[Jake F]

I'm working on a database, the back end will be on a server and the .mde file
will be on the users' computers. There are going to be 125 users accessing
the database within a two hour period, how does the back end handle that in
terms of when the data is updated?

 

[Valentín]

Jake,

the backend data is updated on-line. The number of users is not
important, the number and complexity of operations is much more
important.

If this is critical you may use transactions. A transaction in a set
of database modifications that must be completed or returned to the
initial situation.

This is a complex issue, if you need further info let us know your
requirements.

Best regards,

Valentín
*****************************************************************************

 

[Tony Toews [MVP]]

I'm working on a database, the back end will be on a server and the .mde file
will be on the users' computers. There are going to be 125 users accessing
the database within a two hour period, how does the back end handle that in
terms of when the data is updated?

If each are entering/updating 100 records in that two hours you could
very well have problems. But if entering 2 or 5 records in that two
hours you'll likely be ok. Memo fields were more prone to
corruption in years past. Are they now? We don't hear much about
them being a problem these days.

But notice how my answers are kinda vague.

Tony