Split & Secured Database Shortcut

[Guest]

I have a split and secured database. I created the shortcut and it works as
long as I leave the front end of the database with the back end. If I move
the front end off the network and onto the desktop PC, it no longer works. I
have opened the shortcut and modified the paths to locate the front end and
the shortcut does not work. It gives me the following error notice:
"Microsoft Office Access couldn't find file "---(path to the workgroup
file)-----\L". This file is required for startup.

Do I have an error in the shortcut or the structuring of the split database?

 

[Jack MacDonald]

Did you modify the path to the workgroup file as well as the path to
the database file? It is also in the shortcut target. If you haven't
done so, the workgroup file should be in a shared network location.
All users must have full read-write permissions on the folder.

I have a split and secured database. I created the shortcut and it works as
long as I leave the front end of the database with the back end. If I move
the front end off the network and onto the desktop PC, it no longer works. I
have opened the shortcut and modified the paths to locate the front end and
the shortcut does not work. It gives me the following error notice:
"Microsoft Office Access couldn't find file "---(path to the workgroup
file)-----\L". This file is required for startup.

Do I have an error in the shortcut or the structuring of the split database?

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

 

[Guest]

Jack

I am not the originator of this thread, however I am experiencing the exact
same problem.

I used the user level security Wizard to set up user names etc. After this I
split the data base with the BE on a share drive and the FE installed on each
users C:\ Drive. There was a short cut created by the Security wizard which i
have installed on each users desktop. The problem is that when you click on
the short cut, the user is still accessing the FE that is still on the share
drive (with the BE) If I delete the FE from the share drive, I get the same
problem as the other chap.

I suppose there are two questions to ask:-

1. Is there a way of moving the workgroup file (I cannot even find the
Workgroup file!!!!) so that it allows the short cut to open the FE on the
users C:\Drive

or

2. Is there a way of reversing what the User level security wizard has done
so that I can click on the FE directly rather than opening the front end via
the short cut that was created by the security wizard?

Hope I have not confused you!!

Regards

 

[TC]

I haven't read this thread in detail, but maybe this will help.

- If a database is correctly secured, but you do /not/ want security to
apply to other databases on the PC, then, you must use a shortcut to
run the secured database.

- The shortcut target includes the paths to the secured FE database,
and the appropriate workgroup file. You can put those things where-ever
you want, as long as you amend the shortcut target's paths accordingly.

HTH,
TC

 

[Guest]

TC

I have tried to change the short cut properties but I get the same error as
NB does.

I want to be able to remove the user level security and not have to bother
with the short cut.

Is there a way to do this without buggering up the data base???

 

[Keith]

I want to be able to remove the user level security and not have to bother
with the short cut.

Is there a way to do this without buggering up the data base???

Yes, give the "Users" group full permissions to all database objects,
including the database object itself.

Regards,
Keith.
www.keithwilby.com

 

[Joan Wild]

I used the user level security Wizard to set up user names etc. After this
I
split the data base with the BE on a share drive and the FE installed on
each
users C:\ Drive. There was a short cut created by the Security wizard
which i
have installed on each users desktop. The problem is that when you click
on
the short cut, the user is still accessing the FE that is still on the
share
drive (with the BE) If I delete the FE from the share drive, I get the
same
problem as the other chap.

I think that it may have to do with how you installed the shortcut on each
users desktop (i.e. perhaps you really created a shortcut to your shortcut).

check the target of the shortcut on a user's PC. It should have the
following
"path to msaccess.exe" "path to frontend" /wrkgrp "path to secure mdw"

Do not assume that the path to msaccess.exe is the same on everyone's
computer. Path to frontend needs to reflect the location of the frontend on
their C: drive. Path to secure mdw - You can use UNC pathnames for this
(you should put the mdw in the same folder as the backend on the server).

I suppose there are two questions to ask:-

1. Is there a way of moving the workgroup file (I cannot even find the
Workgroup file!!!!) so that it allows the short cut to open the FE on the
users C:\Drive

Yes, to find it open your shortcut (the one the wizard created) and check
the target - it will show you the path to the secure mdw. Move it to the
server.

2. Is there a way of reversing what the User level security wizard has
done
so that I can click on the FE directly rather than opening the front end
via
the short cut that was created by the security wizard?

Yes there is. Provided you didn't decline, the wizard likely created a .bak
file in the same folder as the frontend on your machine. You just need to
rename this to have a mdb extension.