断开前端从后端打开的链接表与从be执行的vba [英] Disconect linked tables opened in front end from back end with vba executed from be

问题描述

哇..


好​​的，在win xpsp2中运行访问权限2003并在win vista中访问2007.


这就是问题所在。 ..


我们有一个数据库，分为前端（FE.mdb）和后端（BE.mdb）


FE有吨来自BE的链表。


所以问题是......我想在BE中编辑表的设计，有没有办法说，打破链接或连接活动使用后端本身执行的代码到后端的表格。


请不要发布答案，其中一个表格可以在启动时在隐藏视图中打开，前端链接到一个在后端的表格中，当一个值在这样的表格中被更改时，会弹出一个模态表格并在一定时间后关闭访问权限，这不是我正在寻找的答案。


我在想，如果前端有一个tabledefs.connect属性，后端是否有类似内容，我的意思是，有类似tabledefs.connect属性的表在支持中，如果存在，可以将其设置为null，以便中断前端中的链接。 Access知道桌子在前端打开的时间，但是该属性是什么，如何访问它，以及是否可以修改它？


我不是故意要成为粗鲁或类似的东西，但请不要发布答案，如更好的方法将... ...


请将此问题视为概念证明，这里的意思是重要的，而不是结束本身。


Regads，

Whew..

OK, running access 2003 in win xpsp2 and access 2007 in win vista.

This is the question...

We have a db, split in front end (FE.mdb) and backend (BE.mdb)

FE has tons of linked tables from BE.

So the question is... I want to edit the design of a table in BE, is there a way to say, break the links or connections active to the table in the backend with code executed from the backend itself.

Please do not post answers where one could have a form open at startup in hidden view in the front end linked to a table in the backend and when a value is changed in such table a modal form pops ups and after a certain time it closes access, that is not the answer i''m looking for.

I was thinking, if there is a tabledefs.connect property in the front end, is there something similar in backend, i mean, is there something like a tabledefs.connect property for tables in the backed, and if it exists, could it be set to null so to break the links in the frontends. Access knows when a table is open in front ends, but what is that property,how could one access it, and if it can me modified?

I don''t mean to be rude or anything like that, but please do not post answers like "a better approach to this would be...".

Please think of this question as a proof of concept, here the mean is the important, not the end itself.

Regads,

推荐答案

以下是参考资料来源该怎么办。第二个在第一个链接中引用。

http://www.granite.ab.ca/access/relinkingtables.htm

http://www.mvps.org/access/tables/tbl0009.htm

Here are reference sources that tell what to do. The second is referenced in the first link.

http://www.granite.ab.ca/access/relinkingtables.htm

http://www.mvps.org/access/tables/tbl0009.htm

感谢您的提示回复m8。


但是，让我重新解释一下这个问题：


你能检查一下BE.mdb中的表是否在其他地方打开databasese，无论是在FE还是其他数据库中。


我看到了tabledefs.connect属性，但这似乎只适用于FE上的链表。


但问题仍然存在：


1.当有人链接到BE中的表并将其打开到另一个数据库中时，您无法编辑在backingnd中的表。因此，有一种方法可以让Access知道某个表在另一个数据库中是打开的。


2.有没有办法知道BE中的表是否在FE中打开而没有试图编辑表的设计并以只读模式提示打开？


3.如何在后端中断连接或指向表的链接。


也许我不能说清楚：


有没有办法可以在后端用一个按钮创建一个表单你可以点击它，它会关闭前端桌子上打开的所有连接，所以你可以编辑表格的设计吗？


我做了一些研究但是从我所看到的，你将不得不干涉关闭交易或关闭连接，甚至使用ado，adodb或dao操作，这就是我的头脑。


问候，

Thanks for the prompt reply m8.

However, let me rephrase the question:

Can you check if a table in the BE.mdb is open in other databasese, be it in the FE or another database.

I saw the tabledefs.connect property, however that seems to work only with the linked tables on the FE.

However the question remains:

1. when someone has linked to a table in the BE and has it open in another database, you cannot edit the design of the table in the backednd. So there is a way in which Access knows that a table is open in another database.

2. Is there a way to know if a table in the BE is open in the FE without resorting to try to edit the design of the table and get the Open in Read-only mode prompt?

3. How could one break the connection or the links to the table in the backend.

Perhaps I''m not making myself clear:

Is there a way where one could have a form in the backend with a button where you could click it and it would close all the connections open on the tables in the frontend, so you could edit the designs of the tables?

I''ve doing some research but from what I''ve seen, you would have to meddle with closing transactions or closing connections, or even use ado, adodb or dao operations, and that''s way over my head.

Regards,

因此，如果我理解正确，您希望能够在BE数据库打开的情况下确定其任何表当前是否从其他地方打开。据推测，这将包括FE的副本以及在其他地方打开BE本身的人。此外，任何可能的解决方案都不应包含代码。


这是否是您问题的公正表达？

So, if I understand you correctly, you want to be able to determine, with the BE database open, whether or not any of its tables are currently open from elsewhere. Presumably that would include from copies of the FE as well as someone opening the BE itself somewhere else. Also, any potential solution should not include code.

Is that a fair expression of your question?

这篇关于断开前端从后端打开的链接表与从be执行的vba的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！