需要帮助pleaseeee ...更新表格 [英] Need help pleaseeee...updating tables
问题描述
大家好。
我一直试图寻找我的问题的答案，在小组中做一些
搜索，但没有运气。我使用ODBC链接了一个表。
然后我将链接表的副本复制到我的本地计算机上（所以我的
查询可以运行得更快，因为它很慢链接表）。
一切正常但链接表每次都在变化（这是一个
发票表）。我想要的是每次打开数据库时使用链接表自动更新本地
表的方法。什么是
最佳解决方案？
提前致谢
Hello all
I have been trying to look for the answer to my question doing some
search in the groups but no luck. I have linked a table using ODBC.
Then I made a copy of the link table to my local computer (so my
queries can run faster, it was paintful slow with the link table).
Everything works fine but the link table changes everytime (it is an
Invoice table). What I want is a way to automatically update my local
table with the link table everytime I open the database. What is the
best solution for this?
Thanks in advance
推荐答案
我尝试了更新查询，它可以工作......但是它非常慢。另外还有
。
I tried the Update Query, it works...BUT its veryyyyyy slow. There has
to be another way around.
1月24日，12：41 pm，erick-flores < erickjflo ... @ gmail.comwrote：
On Jan 24, 12:41 pm, "erick-flores" <erickjflo...@gmail.comwrote:
我尝试了更新查询，它的工作原理......但是它非常慢。有另外一种方式可以获得
。
I tried the Update Query, it works...BUT its veryyyyyy slow. There has
to be another way around.
如果你想重新创建你的本地表作为
外部表的完全重复，那么你不需要执行更新查询。您可以尝试
来...
- 删除本地表的内容，然后从链接表中执行追加查询
，如在
DELETE local_table。* FROM local_table;
INSERT INTO local_table
SELECT linked_table。*
FROM linked_table;
....或者......
- 使用VBA代码删除本地表，然后重新导入外部
表使用DoCmd.TransferDatabase
If you want to re-create your local table as an exact duplicate of the
external table then you don''t need to do an Update query. You might try
to...
- delete the contents of your local table and then do an Append query
from the linked table, as in
DELETE local_table.* FROM local_table;
INSERT INTO local_table
SELECT linked_table.*
FROM linked_table;
....or...
- use VBA code to drop the local table and then re-import the external
table using DoCmd.TransferDatabase
" erick-flores" < er ********** @ gmail.comwrote
"erick-flores" <er**********@gmail.comwrote
我一直试图寻找我的问题的答案做一些
搜索群组但没有运气。我使用ODBC链接了一个表。
然后我将链接表的副本复制到我的本地计算机上（所以我的
查询可以运行得更快，因为它很慢链接表）。
一切正常但链接表每次都在变化（这是一个
发票表）。我想要的是每次打开数据库时使用链接表自动更新本地
表的方法。什么是
最佳解决方案？
I have been trying to look for the answer to my question doing some
search in the groups but no luck. I have linked a table using ODBC.
Then I made a copy of the link table to my local computer (so my
queries can run faster, it was paintful slow with the link table).
Everything works fine but the link table changes everytime (it is an
Invoice table). What I want is a way to automatically update my local
table with the link table everytime I open the database. What is the
best solution for this?
经过深思熟虑的设计和用户界面通常可以与
链接的ODBC表一起使用。复制整个表格或多个表格很少是痛苦地缓慢的最佳解决方案......因为您经常检索的记录数量远远超过您访问的数量在会议期间。
因此，我犹豫提出好的/更好的做事方式的建议
这可能不是问题的解决方法解决了，但是为了什么
它是值得的：你已经把代码放在了你在
启动参数中指定的表格的事件...菜单工具|启动。但是，我提醒一下，你会更好地描述一下你的情况，因为有人可能会有更好的建议。
我使用ODBC链接到服务器数据库表的经验是，如果你没有走开，那么它们是非常有效的。迫使他们
效率不高。
Larry Linson
Microsoft Access MVP
Well-thought out designs and user interfaces often work just fine with
linked ODBC tables. Copying entire tables, or multiple tables, is rarely
the best solution for "painfully slow"... because you are often retrieving
vastly more records than you will access during the session.
Thus, I hesitate to offer suggestions for good/better ways to do something
that might well not be the way the problem should be addressed, but for what
it''s worth: You''d put the code in an event of the Form you specify in the
Startup Parameters... on the menu Tools | Startup. But, I caution, you''d be
better to describe your situation in some detail because someone may have a
much better suggestion.
My experience with ODBC links to server DB tables has been that they were
surprisingly efficient, if you didn''t "go out of your way" to force them to
be INefficient.
Larry Linson
Microsoft Access MVP
这篇关于需要帮助pleaseeee ...更新表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
