shortcut on network

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

Guest

I secured a database using user level security wizard. It works fine with a
shortcut that was created on my desktop. As expected, when I click open the
shortcut, it asks me for a username and password, which when on supplying
opens the database with assigned permissions. The main access file when tried
to be opened gives the message "You dont have necessary permissions".
Now I have to make this database availble to the users on our network
through Windows Sharepoint. I uploaded the main database file to the
Sharepoint and it was uploaded. But when I try to open the file from there,
it gives the expected message "You dont have necessary permissions" Now I was
trying to upload the shortcut to Sharepoint but it gives me the following
message:
"Form Validation Error
Please correct the information you provided by following these steps, then
submit the information again:
The following file(s) have been blocked by the administrator: Call Center
Sales/MSACCESS.EXE"
I am not even sure if a shortcut can be uploaded but thats the only way to
enter into a secured database. Please advise.
 
I would suspect that this has to do with either (a) an anti-virus program or
(b) some type of security setting on the sharepoint machine.

Also, when moving your db and shortcut, you'll have to move the workgroup
file (the .mdw file) to a public folder (normally it's stored where the
backend is stored) and edit the Target of your shortcut to point to that
file.
 
I have made several .mdw files in the past few days while testing and
learning about security, eg.system.mdw, system1.mdw, system2.mdw. How can I
determine which one is associated with the db (and the associated shortcut).
How can I edit the target of my shortcut to the workgroup file. Thanks.
 
The Target would be something like this:

"Full path to msaccess.exe" "full path to your database" /wrkgrp "full path
to your workgroup file"

You can determine which workgroup you're using to open a specific database
by opening the db, opening the VB Editor (ctrl + f11) and typing this in the
Immediate window:

??dbengine.SystemDB

This will tell you what workgroup is currently being used.

I would also encourage you to use something other than "system.mdw" as the
name of your workgroup file. This is the default workgroup file Access uses.
 
I am having a similar issue. I created an Access database in Access
2000 and created a mdw security file called Secured.mdw to go along
with it. When I use a shortcut to open the database with security, the
database opens fine with security applied. However, I want to get
behind the scenes of the database and need to open the database without
security applied. When I open the mdb file, I get the message, "You do
not have the necessary permissions to use "database name.mdb" object.
Have your system administrator or the person who created this object
for you establish the appropriate permissions for you." How do I get
passed this so the database will actually open without security?
Interesting enough, I do not get this message on Access 2002, Windows
XP (and Windows XP SP1). I only seem to be having this issue with
Access 2003. Any thoughts?
 
mtoigo said:
I am having a similar issue. I created an Access database in Access
2000 and created a mdw security file called Secured.mdw to go along
with it. When I use a shortcut to open the database with security,
the database opens fine with security applied. However, I want to get
behind the scenes of the database and need to open the database
without security applied. When I open the mdb file, I get the
message, "You do not have the necessary permissions to use "database
name.mdb" object. Have your system administrator or the person who
created this object for you establish the appropriate permissions for
you." How do I get passed this so the database will actually open
without security? [snip]
Click to expand...

You don't. You have a user account that has full permissions so that opening the
file with security is not an issue. Security is not something that can be
toggled like a switch.
 
Back
Top