There's a bit more to making the database available to multiple users
than simply copying the file. While it is technically feasible to
share the database by simply copying the file, it is not the
recommended practice.
First, you must ensure that all users have FULL read/write/delete
permissions on the shared folder. If one user has limited rights, that
user can (unintentionally) prevent other users from opening the
database.
Second, it is HIGHLY recommended to split your application and to
distribute a copy of the FrontEnd to each workstations. This site has
plenty of information to offer:
http://www.granite.ab.ca/access/splitapp/index.htm
Once you split the application, you will need a method for
distributing FE updates to each workstation. See:
http://www.granite.ab.ca/access/autofe.htm
On Fri, 30 Dec 2005 10:32:02 -0800, Brenda BN <Brenda
I copied a database from my "home" drive at work to a shared drive at work so
the individuals who need to use it can open the datbase and fill out a simple
form.
They are receiving an error message and can't open it.
How to I give access to a large number of people?
**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
