我可以同时将我的数据库与多个数据库连接吗？ [英] Can I connect my database with more than one database at the same time?

问题描述

我可以在同一时间将数据库连接到多个数据库

can i connect my database with more than database at the sametime

推荐答案

如果您的意思是可以将多个前端数据库连接到后端数据库，答案通常是。这取决于后端数据库是什么以及前端是否以独占模式打开它。由于有很多选项，因此您可以提供更多详细信息。

If you mean can you connect more than one front end database to a back end database, the answer is usually. It depends on what the back end database is and if the front end is opening it in exclusive mode. As there are many options, it would be helpful for you to provide more details.

您可以将多个后端连接到前端。


我目前有一个应用程序连接到4个活动的ACCDB格式化和一个SQL-Server，他们希望我推送到Sharepoint ... YUCK！...因为新的AZURE似乎是下一波浪潮而停滞不前。 br />

您只需要正确构造连接字符串，而且很可能无法使用CurrentDB。编码时的快捷方式，以确保您的连接已命名，以便您可以跟踪它们...个人，避免使用任何非字母数字和下划线字符并了解保留的令牌关键字。

You can have more than one backend connected to the frontend.

I currently have an application connected to 4 active ACCDB formated and an SQL-Server and they want me to push to Sharepoint... YUCK!... been stalling on that as the new AZURE seems to be the next wave.

You simply need to construct the connection strings correctly and more than likely will not be able to use the "CurrentDB" shortcut while coding so make sure that your connections are named so that you can keep track of them... personally, avoid any non-alphanumeric and underscore characters and aware of the reserved, token, keywords.

首先感谢您的快速回复

我所问的是我有一个前端访问数据库，并希望在时间上连接多个后端

但两个后端都有相同的表名

at first thank you for your fast reply
what i asked about is i have one front end access database and want to connect with more than one back end at time
but both back ends have same table names

这篇关于我可以同时将我的数据库与多个数据库连接吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！