Multi user application

[ykhamitkar]

Hi there,

My question is regarding a multi-user project that I am going to develop in ms access. around 20 people will use the same database and they all have ms access installed on their machine.

What i want to know is
"How can I make the ms access file multiuser. would it be right if I split the msaccess file using the 'Database Splitter' option and distribute the ms access file with the forms and reports to different users."

I just want to confirm if it works and all user can get access to the same database file and tables at the same time if i split it.

Thanks
Yogesh

[Scott Price]

Hi there,

My question is regarding a multi-user project that I am going to develop in ms access. around 20 people will use the same database and they all have ms access installed on their machine.

What i want to know is
"How can I make the ms access file multiuser. would it be right if I split the msaccess file using the 'Database Splitter' option and distribute the ms access file with the forms and reports to different users."

I just want to confirm if it works and all user can get access to the same database file and tables at the same time if i split it.

Thanks
Yogesh

Yes, this is one of the main reasons for splitting a database into a 'front-end' (that contains the forms and queries) and 'back-end' (that contains the tables).

You then distribute a copy of the fronted to each user, and link each frontend to the one common backend. Everyone then is updating the same set of data and is able to access the backend at the same time (although because of record-locking, they will not be able to edit specific records that someone else is already editing)

Regards,
Scott