Multi user settings

[Bruce]

I am running Access 2002 service pack 3 on Windows XP professional service
pack 3. I have an application that is shared by two users. They can both add
invoices at the same time with no problem, however when one of them goes to
add another Vendor (Vendor Master Table) that is not currently listed Access
will not let her add the vendor and gives her an error that someone else is
using the system. The settings in the advance tab of the Options drop down
are as follows: Default open mode, Shared; Default record locking, No locks;
Open databases using record level locking is checked. How can set the system
to allow additions to the Vendor table while another using is inputting
invoices? Your attention in this matter would be greatly appreciated.

 

[golfinray]

Change record locks to Edited Record. No locks does not mean no locks! Then
make sure that all users have read/write/edit and delete rights to the shared
BE AND the folder it resides in. Also, there are some patches and hotfixes in
addition to SP3 you need to check on.

 

[John W. Vinson]

I am running Access 2002 service pack 3 on Windows XP professional service
pack 3. I have an application that is shared by two users. They can both add
invoices at the same time with no problem, however when one of them goes to
add another Vendor (Vendor Master Table) that is not currently listed Access
will not let her add the vendor and gives her an error that someone else is
using the system. The settings in the advance tab of the Options drop down
are as follows: Default open mode, Shared; Default record locking, No locks;
Open databases using record level locking is checked. How can set the system
to allow additions to the Vendor table while another using is inputting
invoices? Your attention in this matter would be greatly appreciated.

You should... I'd almost say MUST... use a "split" database for this. The
tables should be in one shared .mdb file; the forms, reports, queries and code
should be in another, typically a .mde file, with each user having their own
individual copy, linked to the "backend" with the tables.

See http://www.ca.granite.com/splitapp.htm for details.

 

[Tony Toews [MVP]]

I am running Access 2002 service pack 3 on Windows XP professional service
pack 3. I have an application that is shared by two users. They can both add
invoices at the same time with no problem, however when one of them goes to
add another Vendor (Vendor Master Table) that is not currently listed Access
will not let her add the vendor and gives her an error that someone else is
using the system.

You want to split the MDB into a Front End MDB containing the queries,
forms, reports, macros and modules with just the tables and
relationships in the Back End MDB. 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
free Auto FE Updater utility at http://www.autofeupdater.com/ to make
the distribution of new FEs relatively painless.. The utility also
supports Terminal Server/Citrix quite nicely.

Tony