Sharing of a access file on a network

[Guest]

Dear Sir,

We have made a access file which is hosted on the common share folder on the
file server.

We require 5 persons to log into this access database and make simulatenous
submission of data for our internal data collection purposes.

We have made the file but it denies multiple access due to security reasons.

We would appreciate your help on the same.

This is further to say that we use Windows- XP Pro in our LAN environment.

 

[Rick Brandt]

Dear Sir,

We have made a access file which is hosted on the common share folder
on the file server.

We require 5 persons to log into this access database and make
simulatenous submission of data for our internal data collection
purposes.

We have made the file but it denies multiple access due to security
reasons.

We would appreciate your help on the same.

This is further to say that we use Windows- XP Pro in our LAN
environment.

ALL users need FULL permissions to the file AND to the folder where it resides.
By full permissions on the folder I mean they need the ability to create new
files, edit existing files, and delete existing files. This is required so
Access can properly manage the locking file (LDB) needed when multiple users are
involved. Yes this does mean that any user can delete your MDB file entirely.

Your app should also be split into a shared data file and separate front end
files that are given to each individual user. That increases performance and
reduces the chances of file corruption.

 

[Tony Toews]

We require 5 persons to log into this access database and make simulatenous
submission of data for our internal data collection purposes.

We have made the file but it denies multiple access due to security reasons.

You want to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite
nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm