使用C#连接到已打开的AccessDatabase [英] Connection to Already opened AccessDatabase Using C#

问题描述

你好，

我正在尝试连接到已为其他目的打开的Access数据库.
我认为数据库已被独占锁定.
我无权更改辅助功能.
我必须从数据库获取实时数据.

是否有任何克隆数据库的方法，以便每当更新原始DB sis时，它都会自动在我的(克隆)数据库中更新(Updataed)?

还是有任何其他方法可以使用C#连接到已连接的Access数据库.

在此先感谢.

请回复.

Lakshman

Hello,

I am Trying to Connect to an Access Database Which is Already Opened for other Purpose.
I think the Database is Exclusively Locked.
I have no Permission to Change the Accessiblity.
I have to Get the Live data From the Databse.

Is there any Method for Cloning the database so that whenever the Original DB sis Updated, it automatically gets Updataed in my (Clonned) Database?

Or is there Any Other Method to Connect to already Connected Access database Using C#.

Thanks in Advance.

Kindly Reply.

Lakshman

推荐答案

否，Access中没有可用的克隆.也没有通知服务会告诉您数据已更新.您必须轮询所需的任何更改，但这也意味着必须更改数据库设计以适应此要求.

该文件在打开时仅由Access锁定.您甚至无法复制文件，因为复制操作将无法打开该文件以读取文件.

No, there is no cloning available in Access. There is also no notification service that will tell you the data has been updated. You have to poll for whatever changes you want, but that also means your database design must change to accomodate this.

The file is locked exclusively by Access when it''s open. You cannot even copy the file since the copy operation won''t be able to open it to read the file.

创建一个新的Access数据库，并使用链接表"向导.可以在这里找到设置表链接的说明；

链接到外部数据 [ ^ ]

您将需要显示链接到另一个Access数据库中的数据"的部分:)

Create a new Access-database, and import the tables into there using the "link table" wizard. Description of setting up table-links can be found here;

Link to external data[^]

You''ll need the part that says "Link to data in another Access database" :)

这篇关于使用C#连接到已打开的AccessDatabase的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！