security problem

[Jorge Collazo]

Version: Access 2k
OS: XP Pro

I have a secured DataBase which I have moved to a new laptop so I can
use it on the road (not connected to the network).

PROBLEM:

When I try to run the .mdb file on the laptop I get a message that says
I do not have the neccessary permissions to access the .mdb object.

QUESTIONS:

1. Does this have something to do with the system.mdw file?

2. If so, how do I fix the darn thing?

[Rick Brandt]

"Jorge Collazo" <jc******@socal.rr.com> wrote in message
news:yb*****************@twister.socal.rr.com...

Version: Access 2k
OS: XP Pro

I have a secured DataBase which I have moved to a new laptop so I can
use it on the road (not connected to the network).

PROBLEM:

When I try to run the .mdb file on the laptop I get a message that says
I do not have the neccessary permissions to access the .mdb object.

QUESTIONS:

1. Does this have something to do with the system.mdw file?
Yes
2. If so, how do I fix the darn thing?

You need to copy both the mdb and the mdw used to secure it to the laptop.

[Jorge Collazo]

Rick Brandt wrote:

"Jorge Collazo" <jc******@socal.rr.com> wrote in message
news:yb*****************@twister.socal.rr.com...

Version: Access 2k
OS: XP Pro

I have a secured DataBase which I have moved to a new laptop so I can
use it on the road (not connected to the network).

PROBLEM:

When I try to run the .mdb file on the laptop I get a message that says
I do not have the neccessary permissions to access the .mdb object.

QUESTIONS:

1. Does this have something to do with the system.mdw file?

Yes

2. If so, how do I fix the darn thing?

You need to copy both the mdb and the mdw used to secure it to the laptop.

Which .mdw file do I copy to the laptop, the one in the MSoffice dir, or
the one in the user directory?

[Rick Brandt]

"Jorge Collazo" <jc******@socal.rr.com> wrote in message
news:nm*****************@twister.socal.rr.com...

Which .mdw file do I copy to the laptop, the one in the MSoffice dir, or
the one in the user directory?

Whichever one was used to secure your mdb. If you are not defining the mdw
to use with a special shortcut then whichever file has been set as your
default mdw is the one you are using. You should be able to use the
Workgroup Administrator utility to determine what your default mdw is.

You could also just open your app and examine both of these directories.
The folder containing the mdw file in use will have a locking file added to
it that is the same name as the mdw file but with an ldb extension.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Jorge Collazo]

Rick Brandt wrote:

"Jorge Collazo" <jc******@socal.rr.com> wrote in message
news:nm*****************@twister.socal.rr.com...

Which .mdw file do I copy to the laptop, the one in the MSoffice dir, or
the one in the user directory?

Whichever one was used to secure your mdb. If you are not defining the mdw
to use with a special shortcut then whichever file has been set as your
default mdw is the one you are using.

How do you 'define' a mdw file within a shortcut?

You should be able to use the Workgroup Administrator utility to determine what your default mdw is.

I don't seem to have the Workgroup Admin util installed. Is it in the
office 2000 install disc?

[Rick Brandt]

"Jorge Collazo" <jc******@socal.rr.com> wrote in message
news:im****************@twister.socal.rr.com...

How do you 'define' a mdw file within a shortcut?
"full path to MSAccess.exe" "full path to mdb" /wrkgrp "full path to mdw"

You should be able to use the

Workgroup Administrator utility to determine what your default mdw is.

I don't seem to have the Workgroup Admin util installed. Is it in the
office 2000 install disc?

In Access 97 and 2000 you look for WRKGADM.EXE. It will either be in the Office
folder or the System32 folder. I believe the newer versions have it available
from within Access itself.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com