Re: Multiple Users entering data at same time

Tech-Archive recommends: Fix windows errors by optimizing your registry

"Karen" <Karen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:F3D43BDC-6D15-4B92-A94C-5756D64DB5FB@xxxxxxxxxxxxxxxx
Hi

I have created a database where multiple users from different departments
need to check off a check box on a form (different check box for each
department) but can be done at the same time. Can I have multiple users on
the same database maintaining different fields at the same time, but all are
doing it on the same form.


There are two issues here, database splitting and record locking. You should split your database and provide each user with their own user-interface file (aka "front-end"). Failure to do this leaves you open to the possibility of file corruption.

Record locking will only be an issue if two or more users try to edit the same *record* simultaneously.

Post back if you need more info.

Keith.
www.keithwilby.com

.

Relevant Pages

  • RE: Merging with Word
    ... You state that your application is not a "spilit" database application. ... you have multiple users and you are attempting to have everyone ... There is no reason for not splitting an application when there are going to ... what I tried is to have Access open a Word Doc and fill in the ...
    (microsoft.public.access.modulesdaovba)
  • Re: MS Access already opened exclusively error
    ... multiple users. ... I also had default record locking ... MS Access to open a database. ... I had a VB app with 50 users accessing ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Activate/Enable Multiple users
    ... Access should allow multiple users to select, add, modify, or delete records ... Jerry Whittle, Microsoft Access MVP ... The database does not allow multiple users to add or edit records at ... Microsoft Office Access can't save design changes or save to a new ...
    (microsoft.public.access.queries)
  • Re: Choosing a Windows Database
    ... >> use some kind of relational database. ... >> multiple users can access and something scalable and fast. ... >> ADO.NET or ODBC provider. ... >> out there using the DBF type files. ...
    (microsoft.public.vb.database)
  • Re: Network
    ... I was planning to load the database on to the server and have ... it is not *recommended* to have multiple users in the same ... The "best practice" is to split the application into a data file (tables ... not recommend that if the data is mission critical and I would certainly ...
    (microsoft.public.access.gettingstarted)