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

Locked Out but I have Workgroup File & Password

P: n/a
I have an Access 97 secured database which I designed myself. I have the
workgroup file and I have been both been trying to access it using a custom
shortcut--which I updated to reflect the current filepaths of both the
database and workgroup file--and I also tried just manually joining the
workgrup file and double-clicking the aplication. I was successful at
"joining" the workgroup file.

I keep getting 'You Don't Have the Necessary Permissions" before it even has
a chance to ask me for the password. I did restore these files from a CD but
I do remove the "read-only" attributes from them first.

Why is it doing this?

Again I know the password of the workgroup file and I am the flat-out
administrator. But I won't even let me get to the point of asking for the
user id & password.

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


P: n/a
"Larry R Harrison Jr" <no***@noone.com> wrote in message
news:a6Z1d.92256$yh.58831@fed1read05...
I have an Access 97 secured database which I designed myself. I have the
workgroup file and I have been both been trying to access it using a custom shortcut--which I updated to reflect the current filepaths of both the
database and workgroup file--and I also tried just manually joining the
workgrup file and double-clicking the aplication. I was successful at
"joining" the workgroup file.

I keep getting 'You Don't Have the Necessary Permissions" before it even has a chance to ask me for the password. I did restore these files from a CD but I do remove the "read-only" attributes from them first.

Why is it doing this?

Again I know the password of the workgroup file and I am the flat-out
administrator. But I won't even let me get to the point of asking for the
user id & password.


Does your custom shortcut point to the file or the Access executable? It
needs to do the latter any time you try to use command line parameters.

"Path to MSAccess.exe" /wrkgrp "Path to mdw" "path to mdb"
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

P: n/a
That is how I have it.
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:2q*************@uni-berlin.de...
"Larry R Harrison Jr" <no***@noone.com> wrote in message
news:a6Z1d.92256$yh.58831@fed1read05...
I have an Access 97 secured database which I designed myself. I have the
workgroup file and I have been both been trying to access it using a

custom
shortcut--which I updated to reflect the current filepaths of both the
database and workgroup file--and I also tried just manually joining the
workgrup file and double-clicking the aplication. I was successful at
"joining" the workgroup file.

I keep getting 'You Don't Have the Necessary Permissions" before it even

has
a chance to ask me for the password. I did restore these files from a CD

but
I do remove the "read-only" attributes from them first.

Why is it doing this?

Again I know the password of the workgroup file and I am the flat-out
administrator. But I won't even let me get to the point of asking for the user id & password.


Does your custom shortcut point to the file or the Access executable? It
needs to do the latter any time you try to use command line parameters.

"Path to MSAccess.exe" /wrkgrp "Path to mdw" "path to mdb"
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #3

P: n/a

"Larry R Harrison Jr" <no***@noone.com> wrote in message
news:Yq02d.92282$yh.462@fed1read05...
That is how I have it.


Are you absolutely positive the shortcut is pointing to the correct mdw?
That's the only other thing I can think of. You can execute a command that
will tell you which workgroup file is being used once you are in the file,
but I don't know of a way to test the mdw being used when you are denied.

MsgBox(SysCmd(acSysCmdGetWorkgroupFile))
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.