动态表链接 [英] Dynamic Table Linking
问题描述
大家好，
我的问题是根据用户登录来更改我的前端链接到哪个后端。我正在使用Access 2000和Windows 98，但不同的用户将使用不同版本的Windows。
我明白我可以在VBA中使用IN功能，例如
Hello all,
My problem is about changing which Back End my Front End is linked to depending on which user logs in. I''m using Access 2000 and Windows 98, however different users will be using different versions of Windows.
I understand that I can use the IN function in VBA such as
推荐答案
您是否在打开数据库时询问如何动态地重新链接链接表？
我认为这将非常困难，容易发生错误，而不是多用户兼容。
我知道无论如何都无法做到这一点。
Are you asking how, dynamically, to relink linked tables when a database is opened?
I think this would be very difficult, prone to errors and not be multi-user compatible.
I know of no way to do this either btw.
您是否在打开数据库时询问如何动态地重新链接链接表？
我认为这将非常困难，容易出错并且不能与多用户兼容。
我知道无论如何也无法做到这一点。
Are you asking how, dynamically, to relink linked tables when a database is opened?
I think this would be very difficult, prone to errors and not be multi-user compatible.
I know of no way to do this either btw.
是的，这就是我要问的。我们有四个单独的数据转移，并希望避免将所有数据放在一个后端。我们希望一个前端能够根据用户引用不同的后端。
从我的帖子开始，我一直在思考它，以及你对多用户不兼容的看法让我大吃一惊。
我正在调查VB中的TransferDatabase函数，它应该重新链接表。如果我得到任何工作，我会发布。
Yes, that''s what I''m asking. We have four shifts with seperate data and would like to avoid putting all data into one back end. We were hoping one front end would be able to reference different back ends based on the user.
Since my post I''ve been thinking about it more and what you said about multi-user incompatibilty crossed my mind.
I''m looking into the TransferDatabase function in VB that should relink the tables. I''ll post if I get anything to work.
我有一个我开发的数据库，它有两个不同的后端。
我处理它将表连接到它们并在检测到它时将相应的集重命名到位。
为了避免多用户问题，我有两个前端数据库存储，每个选项一个。这似乎是浪费时间，但这意味着每当我必须发布新版本时，我都可以释放相同的数据库，因为知道一个人将自动重定向到正确的后端。
这可能是一个值得关注的概念。
如果是这样，我会尽量记住明天的工作，为你挖出一些代码。
I do have a database that I developed which has two different back ends.
I handle it by having linked tables to both of them and renaming the appropriate set into place on detection of which that is.
To avoid the multi-user issue I have have two Front-end databases stored, one for each option. This may seem like a waste of time, but it means that whenever I have to release a new version I can release the same database to both in the knowledge that one will redirect itself automatically to the correct back-end.
Might this be a concept worth following.
If so, I''ll try to remember tomorrow at work to dig out some code for you.
这篇关于动态表链接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
