How can I allow multiple users at once?

[alexandervj]

I have an access database and I plan on splitting it so the FE will be on each users workstation and the backend will be in a folder on the server. But is there anything else I need to do to allow for the possibility of multiple users using the database and changing info at the same time? Thanks

[June7]

That's basically all I do.

With our workflow there is almost no chance of multiple users editing the same record at the same time. Is that a significant concern in your situation?

[alexandervj]

Its not a huge concern but its a possibility. What would happen if that were the case? One persons edits of a record might not get saved? Is there anything else I need to worry about? Thanks June

[June7]

It will trigger a rather confusing warning popup to user and yes, likely one user's edits will not be saved.

If there are any procedures that require writing records to a 'temp' table (temp meaning the records are purged each time the process runs), the table must be in the frontend so users can run the process without interfering with each other.

[orange]

If you can plan you work so different users work with
a) different clients
b) different regions, States....

It depends on the kind of work people are doing. I've seen cases where users were dealing with different NAICS codes, so separation of records for edit was quite easy.