Permissions

[JS1171]

I created an access database on a server. We had to move servers and now I
can't get into it. The database says I do not have permissions to view the
file. can anyone help with this.

thanks
JS1171

 

[Tom Wickerath]

This sounds like a question for your server administrator. It appears as if
they may not have assigned you the proper rights for the new server. Can you
copy the file to your local hard drive and open it from there?


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[JS1171]

yes I have moved if off of the server onto my hard drive and even to a
different computer and it still says I don't have the permissions to open it.

thank you

 

[Tom Wickerath]

Hi JS,

Do you see the exact text of the error message anywhere on this page:

http://www.granite.ab.ca/access/corruption/symptoms.htm

If yes, then your database may be corrupt. If you are not seeing the same
message anywhere, then my next question is are you working with a database
that was secured using User Level Security (ULS)? If yes, then have you moved
the Workgroup Information File (file extension is .mdw) to your new server?
Also, have you adjusted the target in a saved shortcut, that includes the
full path to this file (the other alternative [not recommended] being to
permanently join to the .mdw file)?


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[JS1171]

I did not see the error on that page. I have moved the security.mdw to the
same folder. how do you join the 2 together? Thank you for all your help
with this

Hi JS,

Do you see the exact text of the error message anywhere on this page:

http://www.granite.ab.ca/access/corruption/symptoms.htm

If yes, then your database may be corrupt. If you are not seeing the same
message anywhere, then my next question is are you working with a database
that was secured using User Level Security (ULS)? If yes, then have you moved
the Workgroup Information File (file extension is .mdw) to your new server?
Also, have you adjusted the target in a saved shortcut, that includes the
full path to this file (the other alternative [not recommended] being to
permanently join to the .mdw file)?


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

yes I have moved if off of the server onto my hard drive and even to a
different computer and it still says I don't have the permissions to open it.

thank you

 

[Tom Wickerath]

You use a shortcut that includes the following in the target:

1.) The full path to msaccess.exe
2.) The full path to your front-end database file
3.) The /wrkgrp switch and
4.) The full path to the workgroup information file.

The total cannot exceed 255 characters, including all spaces and double
quotes. Here is an example shortcut target for a secured application (all on
one line):

"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" "C:\HCOA\HCOA.mdb"
/wrkgrp "\\fil-nw05-01\HCOA\Secured.mdw"

It helps to use a text editor, such as NotePad, to put all of this together,
as it can be difficult to see in the limited text area available for the
target. Then copy and paste it into the shortcut's target, and test it out.
In the above example, I used a UNC path for the workgroup information file,
instead of relying on a mapped drive letter path, where all users would need
to have the same drive letter mapped identically. I also use UNC paths in the
linked tables in the FE (front-end) application, to avoid headaches
associated with mapped drive letters.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________