Form Permission Denied

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

Guest

I cannot open my deployed database - when I click the icon, I get a "do not
have open/run permission to open it"

I split my database into front-end and back-end.
The front-end opens a form via MDE file.
The back-end is the data tables MDB file.
Everything works on my PC - security is set at user-level, and when I
attempt to open the MDE, I am asked to sign-in, which I can.
The MDE has been set-up via Developer Extensions Start-up and Package wizards.
I installed the Setup Packaged MDE (fron-end) on another PC.
When I click the icon, I get the above error and no option to sign-in - so
it does not open.

I see no additional file that may contain user-group passwords or other
shortcuts.

I assume that I am to put the back-end MDB data on the server, too and will
be able to link across the network from a workstation that also has the
deployed Setup Package MDE installed?

Are these two questions related to my problem?

What am I missing?
 
Check the target of the shortcut on the users PC. The target should have
"path to msaccess.exe" "path to mde" /wrkgrp "path to secure mdw"

If it is missing any part, it's likely that Access is using the default
system.mdw which won't allow them to open a secure database, and rightly so.
 
Do I put the secure.mdw file somewhere on the deployed PCs (server and
workstation)?
I assumed the Package wizard would take care of all of that in the setup.exe
file...
 
The secure.mdw file should be on the server along with the backend. The
frontend should be put on workstations.

I do not use the Packaging wizard, so can't comment on that.
 
The frontend should be on the users workstation; the backend on the server.

You'll need to open the frontend and refresh the links so they point to the
new location of the backend.
 
Back
Top