Form Permission Denied

[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?

 

[Guest]

Using Access 2003

 

[Joan Wild]

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.

 

[Guest]

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...

 

[Guest]

Do I have the front-end mde and back-end mdb files correctly located?

 

[Joan Wild]

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.

 

[Joan Wild]

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.