By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,323 Members | 2,006 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,323 IT Pros & Developers. It's quick & easy.

security problem

P: n/a
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?

Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
"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.

Nov 13 '05 #2

P: n/a


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?

Nov 13 '05 #3

P: n/a
"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
Nov 13 '05 #4

P: n/a


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?

Nov 13 '05 #5

P: n/a
"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
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.