Activate/Enable Multiple users

[zufie]

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

 

[Jerry Whittle]

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.

 

[Ron2006]

Are each of the users running a separate copy of the Front End
(typically this is residing on their own harddrive)?

Ron

 

[zufie]

I believe the problem is data as the users are only entering data and
NOT changing thedesign of forms, queries, reports, etc.

If data, do I make sure that all the users have Read, Write, Create,
and Delete permissions to both the database files
Do you mean at Tools-->Security-->User and Group Permissions?
AND
make sure that all the users have Read, Write, Create, and Delete
permissions to the entire folder where they reside.
Do you mean have my Security Administrator address these permissions
where the entire folder where they reside?

Thank you!
Zuf

 

[zufie]

No, the front end is accessed through an icon on their Novell
application launcher/portal.

Thanks,

John

 

[Jerry Whittle]

Tools-->Security-->User and Group Permissions

Unless you've set up User Level Security, that should not be the problem.

Rather it's a file system permissions issue. Do have your Security
Administrator address these permissions.

Years ago there were problems with Novell and Access but they were all fixed
also years ago.

 

[Ron2006]

No, the front end is accessed through an icon on their Novell .application launcher/portal.

Thanks,

John

That is the cause of the problem.

For proper splitting of an application, each user must be running
their own copy of the Front End, and that will run the fasted if that
copy is on their own hard drive.

Here are some explanations/references for splitting Access DBs


Split your MDB file into data and application
http://allenbrowne.com/ser-01.html

Splitting your Microsoft Access MDB into a front end and back end
http://www.granite.ab.ca/access/splitapp/index.htm

Generally, for a multi-user Access database application, you should
split
the database to Front-End and Back-End MDB file. The Back-End
contains only
Tables and reside on a (file) server shared directory. The Front-End
contain other Access objects and each user should have his own copy of
the
Front-End on his work-station.

See tony Toews' Web site for more info.:


http://www.granite.ab.ca/access/splitapp/index.htm


--
HTH
Van T. Dinh
MVP (Access)

======================

If you do not do that then one of the problems you may encounter is
the one that you are encountering.

Ron