How can multiple users access the same database?

Question

0.00/5 (No votes)

See more:

I want to build a database application with MS Access in a multi-user environment. The purpose of this database is to manage employee data. Such that one can add data in one database and one can update data in the different table at the same time

What I have tried:

I have tried to keep the database in cloud drive but not helpful

Posted 24-Apr-19 6:03am

NIRMAL90

Updated 26-Apr-19 19:05pm

Add a Solution

4 solutions

Solution 1

MS Access in a multi-user environment - Google Search[^]

Posted 24-Apr-19 6:06am

Richard MacCutchan

Solution 4

Lot's of options.

Access can "link" to SQL Server for queries.
SQL Server can import / migrate Access databases.

i.e. Access is not a dead end; and as a "start" it is perfectly fine.

Ways to share an Access desktop database - Access[^]

Posted 24-Apr-19 7:32am

Gerry Schmitz

Solution 5

Access is not beautiful to work with. My experience in the past is it always starts to take more time to develop with Access than using a server based DBMS. MySQL works perfect and is free. If you use Navicat for GUI database development and admin it will have some familiarity for you.

If you do have to work with Access putting a webapplication or webservice in front of the access database on a webserver extends mutli user connectivity since the webserver is effectively the single user that manages all requests.

Another possible nasty work around is to create a whole lot of empty Access database files with linked tables to your master Access database that contains the data and then spread the load amongst your users.

Posted 26-Apr-19 19:05pm

Martin Stevens

Comments

NIRMAL90 1-May-19 14:44pm

HOW TO LINKED TABLES TO MY MASTER ACCESS DATABASE AND HOW CAN I UPDATE THE TEMP ACCESS DB TO MASTER DB

Martin Stevens 11-May-19 20:35pm

Your SQL executes on the empty database with the linked tables. Because the tables are linked they are just that linked to the master database where they will update.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Accepted Answer · 2019-04-24T07:03:00

Although it's possible to use Access in a multi-user environment, I wouldn't recommend it.

First, Access is a file-based database. That means in order for everyone to be able to access the file, it must be stored in a Network Share. That means setting up a Windows Server somewhere on the network so that all the workstations can get to it. You could use an existing workstation as a server, but that's a REALLY bad idea.

You also cannot put the file on a cloud-based service and use it from there. It will not work.

Use a real SQL Server or similar instead.