system.mdw / default / secured mdw等 [英] system.mdw/default/secured mdw etc.

问题描述

是的，我已经下载并阅读了常见问题解答。并搜索了档案。我只是在这里小心翼翼地踩了一下，因为关于将自己锁定在数据库中的警告永远不会超出数据库。一些答案我可能只是通过

来解决问题。但是我不想过多地玩。


我在我办公室的系统上运行安全向导。一切都是通常的

的东西，管理员 - >用户，用户组没有权限。分配权利需要

。在RWOP查询和后端工作方面还没有完成工作

权利，但那是WIP。


这里的一切都很笨拙，但有点harewire在客户端：


1.我（经过一段时间之后）计算出快捷方式必须包含访问exe的

路径 - ; msaccess.exe的路径 到mdb的路径 / wrkgrp" path

到安全的mdw文件。或者是吗？鉴于

访问路径可能不是默认的，我宁愿不必逐个创建

的快捷方式。或者它只是必须包括路径如果我想

使用非默认mdw？我把我的安全mdw放在服务器上。在

客户端，system.mdw仍然在默认位置。这是因为

我还没用过巫师？我实际上更愿意把它留在那里。部分

因为我不想更新每个工作站，所以如果他们愿意，任何用户都可以在没有我的情况下进行Access工作。

就像

admin / blank。


2.如何在我的机器上重新创建system.mdw？


3.这个应用程序中有一个autoupdate thingy。基本上在启动时应用程序

检查表中的版本号与服务器上更新文件夹中保存的mdb相比。如果它是相同的mdb打开。如果不是它打开更新程序

mdb，关闭，更新程序从服务器到工作站的副本重新打开

工作站版本。我在客户端遇到的问题是，它不会在更新文件夹中查看副本。试图打开它，

大概是（？）使用system.mdw。当然，admin / blank在该数据库上没有任何

权限。但是一旦有一个正在运行的Access实例

是不是与任何应用程序使用的mdw相同？在办公室它工作正常，因为

secure.mdw似乎是默认的mdw - 据我所知，在注册表中戳戳

。我在这里是正确的吗？


4.运行wrkgadm.exe与运行用户级安全性向导一样
来自UI的
？


你的，Mike MacSween

Yes, I''ve downloaded and read the FAQ. And searched the archives. I''m just
treading a little carefully here because of the caveats about locking myself
out of the db forever. Some answers I could probably get myself just by
trying things out. But don''t want to ''play'' around too much.

I ran the Security Wizard on my system at my office. Did all the usual
things, admin -> users, users group have no rights. Assigned rights as
required. The job isn''t quite finished in terms of RWOP queries and back end
rights but thats WIP.

Everything is hunky dory here but goes a bit harewire at the clients:

1. I work out (after quite a while) that the shortcut has to include the
path to the access exe - "path to msaccess.exe" "path to mdb" /wrkgrp "path
to secured mdw file". Or does it? Given that it''s just possible that the
path to access may not be the default I''d rather not have to create
shortcuts one by one. Or does it just have to include the path if I want to
use a non default mdw? I''m putting my secure mdw on the server. At the
clients the system.mdw is still there in the default place. Is this because
I haven''t used the wizard? I would actually prefer to leave it there. Partly
because I don''t want to have to update each workstation, and also so that
any of the users can do Access work without me if they want to. Just as
admin/blank.

2. How do I recreate system.mdw on my machine here?

3. There is an autoupdate thingy in this app. Basically at startup the app
checks a version number in a table against an mdb held in an update folder
on the server. If it''s the same the mdb opens. If not it opens an updater
mdb, closes, the updater copies from server to workstation reopens
workstation version. Problem I was getting at the clients was that it
wouldn''t look at the copy in the update folder. Trying to open it,
presumably (?) using system.mdw. And of course admin/blank doesn''t have any
rights on that database. But once there is a running instance of Access
isn''t the same mdw used for any app? At the office it works fine, because
secure.mdw seems to be the default mdw - as far as I could tell from poking
around in the registry. Am I on the right lines here?

4. Is running wrkgadm.exe the same as running the User Level Security wizard
from the UI?

Yours, Mike MacSween

推荐答案

除此之外。在我创建mdw时，我保留了所有内容的记录。

工作组的WID。用户和我目前创建的一个组的PID。但是

找不到Admins组的一个。我是否正确地认为，作为一个内置组中的
，那不是一个PID吗？这是我到目前为止记录的内容：


对于mdw：


名称

公司

WID


我为目前为止创建的一组：


名称

PID


为我创建的每个用户：


名称

密码

PID


如果必须的话，是否有足够的信息来重新创建mdw？


在为管理员创建组ID时提供的文档中

管理员的用户和PID都被描述为<之前创建的> ;.

你的，Mike MacSween

Further to all that. I kept a record of everything while I created the mdw.
WID of workgroup. PIDs of users and of the one group I so far created. But
can''t find one for Admins group. Am I correct in thinking that as its a
built in group there won''t be a PID? This is what I''ve recorded so far:

For the mdw:

Name
Company
WID

for the one group I created so far:

Name
PID

for each user I created:

Name
Password
PID

Is that enough information to recreate the mdw if I have to?

In the documentation that was offered on creation Group ID for Admins and
Users and PID for admin are all described as <previously created>.

Yours, Mike MacSween

" Mike MacSween" < MI ****************** @ btinternet.com>写道：


< snip> 1.我（经过一段时间）计算出快捷方式必须包括

"Mike MacSween" <mi******************@btinternet.com> wrote:

<snip> 1. I work out (after quite a while) that the shortcut has to include

访问exe的路径 - msaccess.exe的路径。 路径到mdb
/ wrkgrp路径到安全的mdw文件。或者是吗？鉴于可能的访问路径可能不是默认值，我宁愿不必逐个创建快捷方式。或者，如果我想使用非默认的mdw，它是否只需要包含路径？我把我的安全mdw放在服务器上。在客户端，system.mdw仍然在
默认位置。这是因为我还没有使用巫师？我宁愿把它留在那里。部分原因是因为我不想更新每个工作站，所以任何用户都可以在没有我的情况下进行访问工作。就像管理员/空白一样。


嗨Mike。


AIUI所有三个（msaccess.exe，FE和mdw）的完整路径是
需要
。我在很多网站上都有很多用户从未遇到过

访问非标准位置。


你说你已经阅读了常见问题解答但是我发现你的理解中存在一些漏洞

:-)我从未使用过安全向导，但如果它修改了你的系统，那听起来好像是一个糟糕的想法的.mdw。正确的方法是

创建一个* new * myfile.mdw并将其放在所有用户都可以看到的地方，

离开所有system.mdw''完整。然后你的快捷命令行将用户的机器（仅限该访问会话）切换到你的mdw，当他们执行它时，你的
。因此，你的应用程序不会在任何机器上查询system.mdw

。

2.如何在我的机器上重新创建system.mdw？


如果你修改了你的system.mdw我相信用

''干净''副本覆盖它会完成这项工作，否则所有你的访问会话将是

打开引用你修改过的system.mdw。

3.这个应用程序中有一个自动更新的东西。基本上在启动时，
应用程序检查表中的版本号与服务器上更新
文件夹中保存的mdb。如果它是相同的mdb打开。如果不是它打开更新器mdb，关闭，更新程序从服务器复制到工作站
重新打开工作站版本。我在客户端遇到的问题是，它不会查看更新文件夹中的副本。试图打开它，大概是（？）使用system.mdw。当然，admin / blank对该数据库没有任何权利。但是一旦有一个正在运行的实例，Access就不是用于任何应用程序的mdw了吗？在办公室，它的工作原理很好，因为secure.mdw似乎是默认的mdw - 就我在注册表中探讨时所说的那样。我在正确的路线
这里？


我想我之前的评论涵盖了其中一些，但我使用的方法是

用户的快捷方式打开批处理文件。批处理文件将我的''公共''服务器文件夹中的我的FE的最新版本复制到他们的C盘，然后打开它。
然后打开它。这样，他们*总是*获得最新版本而不需要

需要在任何地方检查版本号。


例如：

XCOPY" M：\KeithWilby \Public\MyGUI.mdb" C：\ Temp \ MyFolder / I

" C：\Program Files \ Microsoft Office \ Office \ MSACCESS.EXE"

" C ：\Temp\MyFolder\MyGUI.mdb" / wrkgrp" M：\KeithWilby \Public\MyWIF.mdw"


4.运行wrkgadm.exe与运行用户级安全性向导相同从UI？

the path to the access exe - "path to msaccess.exe" "path to mdb"
/wrkgrp "path to secured mdw file". Or does it? Given that it''s just
possible that the path to access may not be the default I''d rather not
have to create shortcuts one by one. Or does it just have to include
the path if I want to use a non default mdw? I''m putting my secure mdw
on the server. At the clients the system.mdw is still there in the
default place. Is this because I haven''t used the wizard? I would
actually prefer to leave it there. Partly because I don''t want to have
to update each workstation, and also so that any of the users can do
Access work without me if they want to. Just as admin/blank.
Hi Mike.

AIUI the entire paths to all three (msaccess.exe, the FE and the mdw) are
required. I have many users across many sites and have never come across
Access being in a non-standard location.

You say you''ve read the FAQ but I detect some holes in your understanding
:-) I''ve never used the security wizard but it sounds like it is a bad
idea if it modifies your system.mdw. The correct way to proceed is to
create a *new* myfile.mdw and place it where all your users can see it,
leaving all system.mdw''s intact. Your shortcut command line will then
switch the user''s machine (for that Access session only) to your mdw when
they execute it. Therefore, system.mdw is not queried on any machine by
your app.

2. How do I recreate system.mdw on my machine here?
If you''ve modified your system.mdw I believe that overwriting it with a
''clean'' copy will do the job, else all of your Access sessions will be
opened referencing your modified system.mdw.

3. There is an autoupdate thingy in this app. Basically at startup the
app checks a version number in a table against an mdb held in an update
folder on the server. If it''s the same the mdb opens. If not it opens
an updater mdb, closes, the updater copies from server to workstation
reopens workstation version. Problem I was getting at the clients was
that it wouldn''t look at the copy in the update folder. Trying to open
it, presumably (?) using system.mdw. And of course admin/blank doesn''t
have any rights on that database. But once there is a running instance
of Access isn''t the same mdw used for any app? At the office it works
fine, because secure.mdw seems to be the default mdw - as far as I
could tell from poking around in the registry. Am I on the right lines
here?

I think my earlier comment covers some of this, but the approach I use is
to have your users'' shortcut open a batch file. The batch file copies the
latest version of my FE from my ''public'' server folder to their C drive and
then opens it. That way, they *always* get the latest version without the
need to check version numbers anywhere.

eg:
XCOPY "M:\KeithWilby\Public\MyGUI.mdb" C:\Temp\MyFolder /I
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"C:\Temp\MyFolder\MyGUI.mdb" /wrkgrp "M:\KeithWilby\Public\MyWIF.mdw"

4. Is running wrkgadm.exe the same as running the User Level Security
wizard from the UI?

正如我所说，我从来没有运行过向导，但我非常怀疑它。我在我的网站上有一个步骤 -

分步示例，您可能会发现它很有用。它确实需要一个

而IMO会让Access安全便士掉线但是一旦它确实...... :-)


HTH - Keith。
www.keithwilby.org.uk

" Keith Wilby" <柯********* @ AwayWithYerCrap.com>在留言中写道

新闻：Xn ************************ @ 10.15.188.42 ......


感谢您回复Keith

"Keith Wilby" <ke*********@AwayWithYerCrap.com> wrote in message
news:Xn************************@10.15.188.42...

Thanks for replying Keith

AIUI所需的全部路径（msaccess.exe，FE和mdw）是必需的。


对。我会这样做的。

我在很多网站上都有很多用户而且从未遇到过
访问位于非标准位置。


当然。但你永远不知道< g>我的3个Office安装都在非标准的

位置。

你说你已经阅读了常见问题，但我发现你的理解中存在一些漏洞
： - ）


很可能。令人惊讶的是，有些时候我不太完全理解事情了！

我从来没有使用过安全向导，但听起来好像很糟糕
想法是否修改了你的system.mdw。


好​​吧，我会走到楼梯脚下！ System.mdw在那里。但是

注册表已被修改为默认值。

正确的方法是创建一个* new * myfile.mdw并放置它所有用户都可以看到它，
让所有system.mdw完好无损。然后，当他们执行时，您的快捷命令行将用户的机器（仅限该Access会话）切换到您的mdw。因此，您的应用程序不会在任何计算机上查询system.mdw。


是的，

我认为我之前的评论涵盖了其中一些，但我使用的方法是让用户的快捷方式打开批处理文件。批处理文件将我的FE的最新版本从我的''public''服务器文件夹复制到他们的C盘
然后打开它。这样，他们*总是*获得最新版本，而无需在任何地方检查版本号。

例如：
XCOPY" M：\KeithWilby\Public \\MyGUI.mdb" C：\ Temp \ MyFolder / I
C：\Program Files \ Microsoft Office \ Office \ MSACCESS.EXE
C：\ Temp \ MyFolder \\ \\MyGUI.mdb" / wrkgrp" M：\KeithWilby \Public\MyWIF.mdw"


是的。这已经变得有点痛苦。我可能会切换到一个简单的xcopy，比如

你的。我必须看看它需要多长时间。我一直告诉他们不要

如果他们不需要等等就把它打开。

AIUI the entire paths to all three (msaccess.exe, the FE and the mdw) are
required.
Right. I''ll do it that way.
I have many users across many sites and have never come across
Access being in a non-standard location.
Sure. But ya never know <g> My 3 installs of Office are all in non standard
locations.
You say you''ve read the FAQ but I detect some holes in your understanding
:-)
Quite possible. Amazingly enough, there are times when I don''t quite
understand things perfectly!
I''ve never used the security wizard but it sounds like it is a bad
idea if it modifies your system.mdw.
Well I''ll go to the foot of our stairs! System.mdw is there. But the
registry has been altered to make mine the default.
The correct way to proceed is to
create a *new* myfile.mdw and place it where all your users can see it,
leaving all system.mdw''s intact. Your shortcut command line will then
switch the user''s machine (for that Access session only) to your mdw when
they execute it. Therefore, system.mdw is not queried on any machine by
your app.
Yes,
I think my earlier comment covers some of this, but the approach I use is
to have your users'' shortcut open a batch file. The batch file copies the
latest version of my FE from my ''public'' server folder to their C drive and then opens it. That way, they *always* get the latest version without the
need to check version numbers anywhere.

eg:
XCOPY "M:\KeithWilby\Public\MyGUI.mdb" C:\Temp\MyFolder /I
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"C:\Temp\MyFolder\MyGUI.mdb" /wrkgrp "M:\KeithWilby\Public\MyWIF.mdw"
Yes. This has become a bit of pain. I may well switch to a simple xcopy like
yours. I''ll have to see how long it takes though. I keep telling them not to
leave it open if they don''t need to and so on.

4运行wrkgadm.exe与从UI运行用户级别安全性向导相同吗？

4. Is running wrkgadm.exe the same as running the User Level Security
wizard from the UI?

正如我所说，我从未运行向导，但我非常怀疑它。我在我的网站上有一个

As I say I''ve never run the wizard but I very much doubt it. I have a

分步示例，您可能会发现它很有用。它确实需要一个
而IMO为Access安全便士下降但是一旦它......： - ）

step- by-step example on my web site which you might find useful. It does take a
while IMO for the Access security penny to drop but once it does ... :-)

它正在下降，它好吗！好吧！


干杯，迈克

It''s dropping, it''s dropping, OK!

Cheers, Mike

这篇关于system.mdw / default / secured mdw等的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！