Activate/Enable Multiple users

I want to Activate/Enable Multiple users on a Access database at the
same time.

The database does not allow multiple users to add or edit records at
the same time.
(not editing the same record at the same time)

The error message that users receive when a second user attempts to
add or edit records at the same time states:

Microsoft Office Access can't save design changes or save to a new
database object because another user has the file open. To save your
design changes or to save to a new object, you must have exclusive
access to the file.

The Microsoft fix on this is: http://support.microsoft.com/kb/824278

Microsoft suggests either implementing source code control by using
the Microsoft Visual SourceSafe Add-In for Access 2003 or
alternatively, distributing local working copies of the database to
each user.

Which method of resolution is the most practical in regard to our
network or security or other concerns?

I ensured that the Default open mode is Shared and that the Default
record locking is Edited record. I compared these settings to another
database which does allow multiple users to access the database at the
same time. The settings are the same for both databases.

I split my database hoping that having a database containing just the
tables (back end) and the front end database containing tables,
queries, forms, reports much like the other database that does allow
multiple users to access the database at the same time, that my
database would thus allow multiple user access.

What must I do to Activate/Enable Multiple users?!

Thank you greatly!

John

.

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: Multidimensional array
    ... where multiple users may run the script simultaneously. ... It isn't the networking aspect that causes a race. ... Since the file in question is a database, I would assume it has some form of allowing multiple users to have access at the same time. ... The race condition described by Ben seems to be only at such a time as the database file has been deleted in order to make changes to the structure, and that should be a rare occurrence once I have this running properly. ...
    (comp.lang.perl.misc)
  • Activate/Enable Multiple users
    ... I want to Activate/Enable Multiple users on a Access database at the ... The database does not allow multiple users to add or edit records at ... The Microsoft fix on this is: http://support.microsoft.com/kb/824278 ...
    (microsoft.public.access.queries)
  • 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: 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)