多个用户如何访问同一个数据库？ [英] How can multiple users access the same database?

问题描述

我想在多用户环境中使用MS Access构建数据库应用程序。此数据库的目的是管理员工数据。这样一个人可以在一个数据库中添加数据，一个人可以同时更新不同表中的数据



我尝试过：



我试图将数据库保存在云端驱动器中但没有帮助

解决方案

尽管可以在多用户环境中使用Access，我不推荐它。



首先，Access是一个基于文件的数据库。这意味着为了让每个人都能够访问该文件，它必须存储在网络共享中。这意味着在网络上的某个位置设置Windows Server，以便所有工作站都可以访问它。你可以使用现有的工作站作为服务器，但这是一个非常糟糕的主意。



您也无法将文件放在基于云的服务上并从那里使用它。它不起作用。



使用真正的SQL Server或类似代码。

多用户环境中的MS访问 - Google搜索 [ ^ ]

很多选项。



Access可以链接到SQL Server进行查询。

SQL Server可以导入/迁移Access数据库。



即访问不是死路一条;作为一个开始它完全没问题。



共享Access桌面数据库的方法 - 访问 [ ^ ]

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

解决方案

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.

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

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[^]

这篇关于多个用户如何访问同一个数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！