Front End Security

[Guest]

Hi there,

I'm new to the security world but have been toying around with all of the
documentation here and have been doing some extra reading on it. You are
correct when you say that there really is no quick way to learn this stuff
other than sitting down and trying to wrap your brain around it!

I'm getting there though!! I just have one quick question for you regarding
FE and BE databases. I have successfully created my custom .mdw file and
placed it on a shared location on the network (call it MyWorkgroup.mdw).

I can successfully open my FE database which is located on my local machine
using a shortcut. The shortcut opens the FE on my computer linked to a BE
database on the network.

So as it sits right now, I have a .mdb file and a shortcut side by side in a
folder on my computer. I was wondering if it was possible to apply the
MyWorkgroup.mdw to the front end application only and not have the shortcut?

I also don't want the workgroup file to impact any other access applications
the other people with the FE may use. Is this possible? I tried to assign
the workgroup file to my frontend app but then it appears to apply to every
other access database I own. If I use the shortcut with "Full path to
MSAccess.exe" /wrkgrp "Full path to mdw file" "Full path to MDB", then that
works fine.

I was just hoping that I could apply the .mdw file directly to the fe and
then deploy this out to the users without the confusion of a shortcut as well.

I hope this makes sense!!!!

Thanks for your time!!

TT

 

[Joan Wild]

Short answer, no.

Access is always joined by default to a mdw file. If you do away with the
shortcut for your secure mdb, then you have to make the secure workgroup
file the default. But you don't want it to affect all mdb files. Can't
have it both ways.

If everyone has a typical install of Access, and you put the frontend in the
same folder on everyone's computer, you can just copy the shortcut to them
as well as the frontend.

 

[Guest]

Thanks Joan!!

I had a feeling that was what the answer was going to be. After doing all
the reading on this topic, I had the impression that this wasn't possible.

Thanks for your time!!

TT