Sharing DB on a secured folder problem

[Guest]

Hi,

I had a perfectly working DB with the front end /back end design and it was
seamless and being shared by the users.I requested the ITD group to look into
a secured folder to hide the back end from the network and to assign me admin
rights so i can add users and apply rights.They applied the folder ownership
rights so i could have control.The DB now has a sharing problem in which only
one person can be on at a time, it worked fine as a viewable folder before
this.Is there something i can do to recreate sharing...i ensured all links
are refreshed to the new directory S:\CUSDB\TRACK WAY_BE.MDB Is there a way
to share a secured folder?

 

[Rick B]

In order to use a Microsoft Access database, the users must have full
permission to the folder in which the file is stored. The .lb file will be
added, changed, and deleted by users of the database.

If you are concerned with security, then secure the file using Access'
built-in user-level security.

Hope that helps,

Rick B

 

[Guest]

Thanks Rick,

Ok but in regards to what you stated, i have full rights and i gave the user
read, write and file scan but not full permission to the folder as i
have.Does this mean that everyone that uses the secured folder must have all
rights?Also, the ITD people did hide the folder to whom ever did not have
rights to it and that was good enough for me......Any advise ..please?

 

[Rick Brandt]

Hi,

I had a perfectly working DB with the front end /back end design and it was
seamless and being shared by the users.I requested the ITD group to look into
a secured folder to hide the back end from the network and to assign me admin
rights so i can add users and apply rights.They applied the folder ownership
rights so i could have control.The DB now has a sharing problem in which only
one person can be on at a time, it worked fine as a viewable folder before
this.Is there something i can do to recreate sharing...i ensured all links
are refreshed to the new directory S:\CUSDB\TRACK WAY_BE.MDB Is there a way
to share a secured folder?

In order to handle multi-user concurrency issues Access creates an LDB file when
the first person opens the file, modifies it as users come and go and
automatically deletes it when the last person closes the file. This means that
all users of the file must have permissions to create, modify, and delete files
on the folders where the front end, back end, and workgroup file are located.

You can make the shared folder for the back end hidden to reduce the chances of
people browsing to it in the network, but you can't restrict the users ability
to create, modify, and delete files in that folder.

 

[Rick B]

They must have full access. As Rick Brandt points out, you can keep the
folder hidden, but a savy user could still find it. A savvy user could open
the back-end directly and manipulate the data at the table level. Access is
not a good solution if you need a very high level of security.

 

[Rick Brandt]

Thanks Rick,

Ok but in regards to what you stated, i have full rights and i gave the user
read, write and file scan but not full permission to the folder as i
have.Does this mean that everyone that uses the secured folder must have all
rights?Also, the ITD people did hide the folder to whom ever did not have
rights to it and that was good enough for me......Any advise ..please?

I don't think it technically qualifies as "full" permissions, but as previously
stated they ALL must have permission to create new files in the folder, modify
existing files in the folder, and to delete existing files in the folder.

Yes, this does mean that a user could delete your mdb file. That is the nature
of using a file-based system. Make regular back-ups and live with it or move to
a server-based engine where you can have more robust security.