Click here to Skip to main content
16,019,843 members
Please Sign up or sign in to vote.
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
Updated 26-Apr-19 19:05pm

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.
 
Share this answer
 
Comments
OriginalGriff 24-Apr-19 14:06pm    
+5Absolutely agree. Although it works, it causes some really nasty problems and it doesn't scale at all well. :thumbsup:
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[^]
 
Share this answer
 
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.
 
Share this answer
 
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.

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900