MS Access - How to split your database and allow multiple users to enter data at the same time

This tutorial will show you how to split your Microsoft Access database so multiple users can enter data at the same time.

By splitting the database, you can create multiple files, also called front end databases, that will all act as a tunnels to your one central data storage location, also called a backend database.

Creating a front end database will also allow you to accommodate preferences for different users. Some users may want certain reports, queries, and forms that are specific to them, whereas others may not.

[eb]

You are the man! Fine example of how tutorial videos should be, clear, concise, and no unnecessary gibberish. Thank you!

[ThePROMediateam]

in case i have autoNumber column in my database in this case if i have multiple users to record the data "front database", which number appear first in the auto number columns for each of them

[excelemployeeleavetracker]

Question: You created a new field called "Favorite Team" on the back end data base, however that field was not visible on the Front End data base. Please explain. Thank -you

[saleem]

i'm using access as a front end for an SQL Server database. Do i need to split the linked tables like in this video to avoid data corruption? or would that be duplicating a step?

[ENGFREEMAN]

Dear... thanks for your sharing ... but what if we need to open these splits from other computers in local network? ... regards

[CamiloSanchez]

Can you tell me how this would work on a network drive and what happens to the VBA code i added? Will it go to the other people as well?

[mastergogoy]

Hello, let's say if I put the backend on a shared network folder and make copies of the front end. Will it still work if I copy the front end from the shared folder into another PC in the same network?

Say, I created the backend on PC1's shared folder and made copies of the frontend too.. Then in PC2, I cut then pasted a copy of the frontend from the shared folder.

[HiralShah]

Have a question here. I have a database that is into lead management. There are three users who needs to enter data into the database. But they work from different computers. Do we need to have a network drive on which the backend will be there. Alternatively can we have the access database on the cloud?

[panduprayudha]

hi sir, wanna ask u something.. nowadays local network been disable, can this backend and front end be share on sharepoint?

[prochefpos]

Question : I split my access database and put it in my shared folder on a computer in my home network for use via wifi with other frontends on different machines. I have a vb6 application that uses this database. All apps sitting on my windows 11 computers have become terribly slow but on my windows 7 computer the speed hasn't dropped much. Is there a reason for this ? thanks.

[ryanm.]

Hi Sir nice job! I just have some questions. If all users operate the database at the same time and 1 user added a record to a form, will the other users able to see it in real-time or should they push a refresh command or something, or maybe restart their database just to update their database? Lastly, if the original database happens to have a login form with password, and then I created a multiple users database, will they be able to use the same password on their database because I happen to search from another tutorial that password will be gone after making another user and u have to redo the login form. thank you for your time answering:)

[waliulislam]

How i distribute the front end copy to different computer user?

[nikolaradovic]

Hi guys, i have problem with acess database, he is created a few year ago (2) and multiple user can use them on sharefolder, but now when 2 user on same time want to acess give message dont have exlusive right to acess .If any know what is answer please reply, thanks 😊

[anudeepreddynare]

⁠I have copied couple of them and distributed to two people ( two different systems in my organization) through email after they download they are unable to access that and enter details. Did I do any thing wrong are we need to send the database copy too ?

[JohnDavis-jgom]

what if you want add data to the database from a different computer?

[kenotube]

Question: At the office, there is an Access database on a network folder, but when one user on one computer updates a record, it doesn't show for the other user, and vice versa. Will splitting the database, as you show here, solve this problem? Thanks!

[akokohjoel]

How can Ms access be link to MySQL online server?

[hvsqfxo]

Can front end change the back end database content? Thank you

[sharmaneaurora]

How to distribute the front end and not lose the connection to the back end?

[driftingforward]

DO you have to have anyting else besides 2 computers? like a server? or a modem? or anything?