Security Rights, Split & Share

[Faraz Ahmed Qureshi]

Unfortunately I am unable to search relevant posts in respect of ACCESS 2007.
I have just completely desigbed up and developed my DB!
Now, I have the following queries, please c if u can help me out in
providing either the tips or relevant sources of info on net in this regard:

1. How to have the users be restricted to unhide the Navigation Bar & peek
into the Table/Queries structure OR access the RIBBON for the said DB?

1A. Any source of info on Net guiding the way to have the users be declared
with different LOGINs + PWs for every user?

2. How to have them restricted from launching the VBA of the said DB (Only
ACCDE? Is it recommended?)

3. I have a different server for the user's department for which I don't
have access at my home where I am designing the said DB. If I have the same
Split and then for any reason have to change the location of the BE how to
have the FE be synchronized with the new address?

 

[Jerry Whittle]

I can help with #3.

You need to create a virtual drive on your computer to match a network drive
for testing. For this you can use the old DOS subst command.

Subst--Example

The following command creates a virtual drive Q for the path
C:\USER\BETTY\FORMS:

subst q: C:\user\betty\forms

Now, instead of typing the full path, you can reach this directory by typing
the letter of the virtual drive, followed by a colon, as in the following
example:
q:

If you are using long file names for the folders, use quotes.
subst q: "C:\My Databases"

To remove the virtual drive:
subst q: /d

You can also create more than one virtual drive at a time. I have two that I
load automatically on my home machine by putting the command lines in the
Autoexec.bat file.

Note: I haven't tried this with Windows Vista or 7, but it does work up to XP.