RE: Activate/Enable Multiple users

Access should allow multiple users to select, add, modify, or delete records
for the most part. However newer versions of Access will not allow multiple
people to create or edit forms, reports, code, tables, or queries (with some
exceptions).

So is the problem data or design? If data make sure at all your users have
Read, Write, Create, and Delete permissions to both the database files and
the entire folder where they reside.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"zufie" wrote:

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: 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)
  • 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)
  • 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 ...
    (comp.databases.ms-access)
Quantcast