Network Share

[Duane]

I am not sure if this is the right forum to ask this question or not, and if
it isn't, I sure would appreciate any direction that could be given.

Our server is setup where there is a couple of drives labeled as PUBLIC
Drives, prefaced with a particular letter such as P: or G:. Everyone has
full access to these drives.

I have created some small databases that specific individuals can
add/edit/delete the data in the database. It is password protected using a
table and logon form. I have created some frontend databases that are
linked to the backends for all staff to only view the data and print some
very basic reports. Everything works fine.

The trouble I am having is that in order for the frontend databases to have
the ability to connect with the backend, the backend database also has to be
in a drive that all users have access to, unfortunately, leaving the
database vulnerable to being deleted, which it has been. Luckily we have a
tape backup and I also have backups being made daily to another drive.

If I move the backend to a different drive that the user cannot see or
doesn't have access to, they get an error message stating that the file
could not be found. Is it possible to correct this problem by having the
database in a secure location yet having the ability for the frontend
databases to find it and connect?

Thanks in advance.

 

[Tom Wickerath]

Hi Duane,

You should be able to set Windows permissions such that all users who have a
need to use a particular BE database have full RWCD privileges on the folder
(so that the locking database file can be created and deleted, as needed),
while removing delete rights from the actual .mdb (or .accdb for the new ACE
format in Access 2007) file.

If you distribute your FE databases correctly linked, using the UNC type
path, there should never be a problem with the FE not finding the BE, as long
as the user is authorized to use that particular FE file. A UNC type path
(ie. \\Server\Share) is a lot less problematic versus a mapped drive letter
(the P: and G: drives you mentioned). You can even include a $ sign in the
name of the folder to make it hidden in Windows. I don't remember if this is
the first character or the last.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________