Get "Access Is Denied" when trying to join workgroup

[Faye Barth]

I have a secured database which has 2 .mdw files: one
created in Access2000 and one in Access97. This is
because the database was originally created in Access97.
The back-end is still in Access97. When some users were
converted to Access2000, I converted the frontend
(nondestructively) and have frontends in both Access97
and Access2000. My own workstation was running
NT4/Access97, and everything was working fine. I was
joined to the Access97 workgroup. I own and have Full
Control over the folder in which the .mdw's and databases
live, and am the owner of the files.
After I was converted, I tried to join the Access2000
workgroup. Got an "Access is denied" message. I even
got that message when I tried to join the backup copy I
had of the workgroup, which was in my "Z" space (space on
the server for my files).
Is there anything else I can do besides create
another workgroup with the same groups & PID's etc, for
my use? Please advise, thanks. F. Barth

 

[Lynn Trapp]

Faye,
Since the database was secured with the A97 workgroup file, you probably
should simply continue to use that one, although you will need to join it
using the A2K workgroup administrator. The "Access is denied" message is
most likely something to do with your operating system settings that don't
allow you to install applications. You will need to talk to your network
adminstrator about that issue, I think. There should be no need to create a
new workgroup.

 

[Faye Barth]

I also get "Access is Denied" when trying to join
the '97 .mdw file. Faye

 

[Lynn Trapp]

Some of the newer network operating systems require you to have "administer"
privileges to your computer to be able to join an access workgroup. Either
your network administrator will need to do this for you or give you
"administer" rights to your computer.

 

[TC]

Is this because of greater protection on the relevent registry key(s)?

TC

 

[Lynn Trapp]

You would need to ask one of the Windows MVPs about that.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm