重新链接访问链接表（多个后端） [英] Relinking Access Linked Tables (Multiple Back-Ends)

问题描述

你好，我在这里总是新手，但是我一直在寻找没有运气的答案。


我用你的功能来刷新我的链接表打开我的数据库的前端。它就像只存在于一个SQL Server数据库中的链表一样。然后我转到了我的下一个前端，它连接了位于3个独立的SQL Server数据库中的表，当然没有任何乐趣。是否可以扩展此代码以查看3个不同的数据库？


提前感谢您提供的任何帮助。


Jennifer

Hello, I''m a total newbie here, but I have been searching for days for the answer to this without any luck.

I used your function to refresh my linked tables upon opening the front end of my database. It worked like a charm for linked tables that reside in only one SQL Server database. Then I moved on to my next front end, that has linked tables that reside in 3 separate SQL Server databases, and no joy, of course. Is it possible to expand this code to look to the 3 different databases?

Thanks in advance for any help you can provide.

Jennifer

推荐答案

嗨Jennifer。


我已经从使用VBA重新链接ODBC表，因为这是一篇文章，你需要一个问题主题。


管理员

Hi Jennifer.

I''ve split this from Relinking ODBC Tables using VBA as that is an article and you need a question thread.

Administrator

目前我没有任何此类数据库可供使用，但如果您可以发布有关的一些详细信息。连接要更改的表格的字符串，以及您想要更改的内容，然后我们可以为您调查。


当前状态的副本与此相关的代码也很有用。

I don''t have any such database to play with at the moment, but if you can post some details about the .Connect strings of the tables you want to change, and what about them you want to change, then we can look into it for you.

A copy of the current state of your code related to this would be helpful too.

这是我上面提到的代码：

http://bytes.com/topic/access/insigh...bles-using-vba


它适用于单个后端，但不适用于多个后端

Here is the code I mentioned I was using above:

http://bytes.com/topic/access/insigh...bles-using-vba

It works for a single back-end, but not for multiple backends

这篇关于重新链接访问链接表（多个后端）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！