Permissions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Data Base which is assigned a password on opening. This works fine,
but when I copy the Data Base to another Computer and try to open it, the
system tells me that I do not have the necessary Permisions to open this
object. The Machine is a Stand Alone.
Any advice as to how to fix this would be appreciated.
 
In addition to copying the mdb file, you need to also copy the mdw file that
was used to secure it with.

On the original computer, check the desktop shortcut that opens the mdb.
You will find the path to the mdw in the target.

If you don't use a desktop shortcut, then Access is joined by default to the
secure mdw. Open Access and go to Tools, Security, Workgroup Administrator
to see what the path is.

Copy that mdw to the other computer, and create a desktop shortcut to start
the mdb.
 
Thanks for your help Joan.
The Workgroup administrator reveals the the file used is System.mdw, which I
understand is the Default in Access. The Password to open the Data Base has
been set by opening the data base in exclusive mode and Tools Security Set
Password. The thing is that I have not had to copy the MDW file to other
users computers in the past and the file has always opened fine and the
password accepted. Is the Password actually stored in the MDW file?
Could it be the Operating System? or what else could be the problem? on that
particular computer.

Thanks again for your professional assistance.
 
Roger Bell said:
Thanks for your help Joan.
The Workgroup administrator reveals the the file used is System.mdw, which
I
understand is the Default in Access.
Click to expand...

The Workgroup Administrator only tells you the mdw set as the default; that
isn't the one necessarily in use. To check the one in use, open the
database, hit Ctrl-G and type
?DBEngine.SystemDb
That will return the mdw in use.

Also even though it is named system.mdw, doesn't mean it isn't secure. It
would be a poor choice for a secure workgroup file, but it isn't necessarily
the system.mdw that ships with Access.

The Password to open the Data Base has
been set by opening the data base in exclusive mode and Tools Security Set
Password.
Click to expand...

OK, So you are never prompted for username/password, just password? If
that's the case, then the workgroup file doesn't matter.

The thing is that I have not had to copy the MDW file to other
users computers in the past and the file has always opened fine and the
password accepted. Is the Password actually stored in the MDW file?
Click to expand...

No, the database password is stored in the mdb file. I misunderstood; I
thought you were referring to username/password.
Could it be the Operating System? or what else could be the problem? on
that
particular computer.
Click to expand...

Check the windows permissions on the folder where you copied it to. The
Windows username running the mdb needs modify permission on the folder. It
sounds like they have insufficient permissions.
 
Thanks again Joan. Have taken your comments on board. I have got around the
problem by copying the System.mdw into the location where the data bases are
stored and used the Tools-Security-Workgroup Administrator and Used the Join
feature to point to this loacation. Could this cause any implications?
It is interesting that other Data Bases worked from the same folder, but not
the one that was Password Protected.

Thanks again for you contribution to this site and to the many novices who
are on a learning path.
 
Back
Top