尝试复制和覆盖文件 [英] Trying to copy and overwrite a file

问题描述

当用户离开包含链接到数据库的数据透视表的excel工作簿的问题时，用户遍布整个地区，因此不像在办公室走动要求每个人关闭他们的文件一样简单。我正在尝试写一个子来复制并粘贴我的数据库的最新版本，即使有活动连接，有什么办法可以强迫这个？目前我的代码很简单

Having issues of users leaving excel workbooks that contain pivot tables linked to a db open, users are located all over the region so it is not as simple as walking around the office asking everyone to close out their files. I am trying to write a sub to copy and paste the newest version of my db over the old even while there are active connections, is there any way to force this? Currently my code is a simple

展开 | 选择 | Wrap | 行号

推荐答案

你可以使你的数据库倍数，所以不止一个人可以同时使用它

从工具转到选项然后提前选项你会发现一些关于默认开放改变它从私人到共享

好运气

you can make your db multiple, so more than one person can use it at same time
from tools go to option then advance option you will find something about default open change it to from private to shared
good luck

@xzorxx：如果可以打开多个，那么它已经处于共享状态。


@pegicity：你试过打开吗？文件上的正常访问会话？根据记录锁，您应该能够直接从Access更改数据。然后用户刷新数据透视表时应该从新数据集中提取。

@xzorxx: if more than one can open then it is already in a shared state.

@pegicity: have you tried to open a normal Access session on the file? Depending on recordlocks, you should be able to alter the data directly from Access. Then the users when they refresh the pivot tables should pull from the new dataset.

通常的做法是为每个用户分配一个单独的前端。这是因为多个用户直接访问同一个数据库文件所涉及的问题以及其他类似的问题。


我怀疑你会发现这种方法可以减少问题。

It''s common practice to allocate a separate front end to each user. This is because of this, and other similar, problems involved with multiple users accessing the same database file directly.

I suspect you would find this approach gives you fewer problems.

这篇关于尝试复制和覆盖文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！