ldb文件和独占访问问题 [英] ldb file and Exclusive Access question
问题描述
我继承了一堆dbs，这些dbs在我的部门的一个小组中共享。我们通常使用dbs编写查询来提取数据，通常是将b / b $ b转储到Excel中。大多数dbs起源于MsAccess 97或之前，并且已经将
转换为2003.在occassion上，用户1将打开一个数据库。当用户2
打开数据库时，它不会让用户2修改宏，什么不能。我可以理解这一点，并意识到我们可以拆分数据库;虽然不值得花时间
。在这种情况下，您始终会看到.ldb文件打开.mdb文件。
用户1打开不同数据库后的其他时间，用户2将完全是
拒绝访问它。他/她获得独家访问消息。在这些
的情况下，似乎没有.ldb文件打开.mdb文件。请注意，
数据库未设置为独占（工具选项高级）
问题是，为什么这些dbs独占锁定，我该如何制作他们像其他人一样
所以人们至少可以进入读取权限吗？
-
OOPs打字错误..不起作用的陈述是：
AdjAmt：Sum（IIf（[TYPE] = 2和Left（Date（），2）=" 07"，[Amt] * [百分比]，IIf（[TYPE] = 1，
I have inherited a bunch of dbs which are are shared among a small group in
my dept. We typically use the dbs to write queries to extract data, usually
dumping it into Excel. Most dbs originated in MsAccess 97 or prior and have
been converted to 2003. On occassion user 1 will open a db. When user 2
opens the db it will not let user 2 modify macros and what not. I can
understand this and realize we could split the db; it is not worth the time
though. In this case you always see a .ldb file open with the .mdb file.
Other times after user 1 opens a different db, user 2 will be completely
denied access to it. He/She gets an exclusive access message. In these
cases there appears to be no .ldb file open with the .mdb file. Note that
the database is NOT set to be exclusive(Tools Options Advanced)
The question is, why are these dbs exclusively locked and how can I make them
like the others so folks can at least get in with read access?
--
OOPs a typo...the statement that DOES NOT work is:
AdjAmt: Sum(IIf([TYPE]=2 And Left(Date(),2)="07",[Amt]*[Percent],IIf([TYPE]=1,
[Amt] * [百分比]，0）））
[Amt]*[Percent],0)))
消息通过AccessMonster.com发布
http://www.accessmonster.com/Uwe/For...ccess/200509/1
推荐答案
明显明显回答是你已经暗示的那个......分开
数据库并分发前端...
the blatantly obvious answer is the one you already hinted at... split
the DB and distribute the front end...
On 2005年9月16日星期五17:54:56 GMT，&q uot; Andre Laplume via
AccessMonster.com" < FO *** @ AccessMonster.com>写道：
不值得的时间???这需要花费大约相同的时间来写你的消息。
为什么人们会继续在他们的背后铐起手来，然后
然后抱怨他们已经失去了他们的灵巧？
-Tom。
On Fri, 16 Sep 2005 17:54:56 GMT, "Andre Laplume via
AccessMonster.com" <fo***@AccessMonster.com> wrote:
Not worth the time??? It would take about as much time as writing
your message.
Why do people continue to cuff their hands between their backs, and
then complain they''ve lost their dexterity?
-Tom.
我继承了一堆dbs在我的部门的一个小组中分享。我们通常使用dbs编写查询来提取数据，通常将其转储到Excel中。大多数dbs起源于MsAccess 97或之前，并且已经转换为2003.在occassion上，用户1将打开一个数据库。当用户2打开数据库时，它不会让用户2修改宏而不是用户2。我可以理解这一点，并意识到我们可以拆分数据库;但是不值得花时间
。在这种情况下，您始终会看到.ldb文件以.mdb文件打开。
在用户1打开不同的数据库之后，用户2将完全被拒绝访问它。他/她获得独家访问消息。在这些情况下，似乎没有.lddb文件打开.mdb文件。请注意，数据库未设置为独占（工具选项高级）
问题是，为什么这些dbs完全锁定，我怎样才能使它们像其他人一样所以大家至少可以进入读取权限？
I have inherited a bunch of dbs which are are shared among a small group in
my dept. We typically use the dbs to write queries to extract data, usually
dumping it into Excel. Most dbs originated in MsAccess 97 or prior and have
been converted to 2003. On occassion user 1 will open a db. When user 2
opens the db it will not let user 2 modify macros and what not. I can
understand this and realize we could split the db; it is not worth the time
though. In this case you always see a .ldb file open with the .mdb file.
Other times after user 1 opens a different db, user 2 will be completely
denied access to it. He/She gets an exclusive access message. In these
cases there appears to be no .ldb file open with the .mdb file. Note that
the database is NOT set to be exclusive(Tools Options Advanced)
The question is, why are these dbs exclusively locked and how can I make them
like the others so folks can at least get in with read access?
让我公然，休息，假设我的手在我面前。关于分裂，你们两个可能都是好的。我接受的工作并没有成长，而是用b / b
拆分dbs。我们有超过30个用Excel表格链接到这里
和那里。另外，我不是他们中唯一的用户，有些人已经在部门中分配了一个数据库。管理层确实希望这个过程改变了
，因为dbs被用于简单的数据提取，通常一次只能一个人使用
。我们不会有时间拆分dbs，也不会给b $ b解释/训练用户基于拆分的时间，也不是时候记录这些更改。
>
我遇到了问题，因为我正在使用任务调度程序自动运行一些
报告。任务调度程序打开一个数据库并运行一个宏。
宏执行一些查询然后调用一个Access函数打开一个
speadsheet，刷新所有数据选项卡（这是哪里安全问题
出现），重命名标签，做一些格式化并将报告写入分享
给最终用户。
这对我们大约一半的dbs一切正常。有些人虽然有''独家
访问''这个问题，但我在任务调度程序打开数据库时，
电子表格不会刷新，因为数据库已经完全打开了。
这里没有人确定为什么有些dbs会独占开放，为什么其他人允许这样做？b $ b b许多有读取权限的人都在数据库中。
由于拆分不是一个选项，我可能会采用一个允许
后续只读访问的数据库，然后使用它并从我的
影响db in并重命名。这可能也可以消除我的问题......虽然
它没有回答原来的问题，为什么有些人打开了，而b / b
其他人没有。
显然你不确定或者你可能会解释为什么和
然后发出你的傲慢言论。
对不起，如果你觉得我浪费了一个帖子，但是如果你不知道答案也许
最好，如果你根本没有回复。
Tom van Stiphout写道：
Let me be blatant, rest assumed my hands are in front of me. You both may be
right about the splitting. The job I took though did not ''grow up'' with
split dbs. We have over 30 of them with Excel sheets linking to them here
and there. Also, I am not the only user of them, there are ohters who have
never split a db in the dept. Management does want the process changed
either as the dbs are cheifly used for simple data extractions, usually by
one person at a time. We will not be given the time to split the dbs nor to
explain/ train the user base on what splitting is nor the time to document
these changes.
I am running into the problem because I am automating the running of some
reports using task scheduler. Task scheduler opens a db and runs a macro.
The macro executes some queries then calls an Access function which opens a
speadsheet, refreshes all the data tabs (this is where the security issue
arises), renames tabs, does some formatting and writes the report to a share
for the end user.
This all works fine for about half our dbs. Some though have the ''exclusive
access'' issue I described so when task scheduler opens the db the
spreadsheets will not refresh because the db is already opened exclusively.
No one here is sure why some of the dbs open exclusively and why others allow
numerous folks in with read access to be in the db.
Since splitting is NOT an option, I could likely take a db that allows
subsequent read-only access, empyy it and import all the queries from my
affected db in and rename it. This may eliminate my problem as well...though
it does not answer the original question as to why some open EXCLUSIVELY and
others do not.
Obviously you are not sure either or you would have perhaps explained WHY and
perhaps then issued your snooty remarks.
Sorry if you feel I wasted a post but if you do not know the answer perhaps
its best if you do not repsond at all.
Tom van Stiphout wrote:
不值得的时间???这需要花费大约相同的时间来写你的信息。
为什么人们会继续在他们的背后铐着手，然后抱怨他们已经失去了他们的灵巧？
-Tom。
Not worth the time??? It would take about as much time as writing
your message.
Why do people continue to cuff their hands between their backs, and
then complain they''ve lost their dexterity?
-Tom.
我继承了一堆dbs，这些dbs在我的部门的一个小组中共享。我们通常使用dbs来编写查询以提取数据，通常是
I have inherited a bunch of dbs which are are shared among a small group in
my dept. We typically use the dbs to write queries to extract data, usually
[引用文本剪辑 - 11行]
[quoted text clipped - 11 lines]
问题是，为什么这些dbs被独占锁定，怎么能我把它们和其他人一样，所以人们至少可以进入阅读权限？
The question is, why are these dbs exclusively locked and how can I make them
like the others so folks can at least get in with read access?
-
留言通过 http://www.accessmonster.com
这篇关于ldb文件和独占访问问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
