Making Access DB to Multiuser

[Drunkenneo]

I have access mdb which is in condition from last year, now its been demanded to make Multi user, if i just split to FE and BE will fiine or i need to work at table level for making it working by multi users. Its not a data entry mdb, its Content management mdb.

Please suggest.

 

[pr2-eugin]

Splitting the DB into FrontEnd and Backend and each user having a Common backend (preferably in a Network location) and a separate, individual copy of the frontend is what makes it a Multi user structure.

 

[Old Man Devin]

Splitting the DB into FrontEnd and Backend and each user having a Common backend (preferably in a Network location) and a separate, individual copy of the Backend is what makes it a Multi user structure.

You probably meant to say a common back end and a separate individual copy of the front end!

 

[pr2-eugin]

You probably meant to say a common back end and a separate individual copy of the front end!

Oh yes ! That I did.

NEED MORE COFFEE !!

 

[Drunkenneo]

Splitting the DB into FrontEnd and Backend and each user having a Common backend (preferably in a Network location) and a separate, individual copy of the frontend is what makes it a Multi user structure.

I want to know suppose if the users working on same table will effect the insertion or saving of the data, say it if they press button for same report generation does it effects.

 

[pr2-eugin]

I want to know suppose if the users working on same table will effect the insertion or saving of the data, say it if they press button for same report generation does it effects.

Prone to contradiction/arguments. Although no one can control what Access decides to do, if User A inserts a new record at the exact same time (probably millisecond difference before) and User B queries the DB, a snapshot of the data is taken, so if User A's save was committed the report will reflect this. If the report was to be queried first then the user A change will not come in the report.

In general, this should be no problem. If your data does not come up with what you expect a simple refresh or requery would do the trick.

 

[Drunkenneo]

Thanks, i will give it a try and get back if more needed