multiple users in access database

[Guest]

I followed the instruction in this link
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm but when I
finished the FE on another computer, we cannot add data on the database at
the same time.

It will say that the record set is not updatable. But I already removed the
locks and the DB should be shared.

To give you a brief history on the database, I made the BE and placed it in
the shared folder. A copy of the FE is in the same folder which is an mde
file. I have the original in my own workstation. I left a copy of the FE so
the other workers can copy and paste it in their own workstation.

But when they open their copy of the FE in their desktop, they cannot add
any data to the database.

Do any of you have any suggestions for me what to do?

Thanks

 

[Guest]

Ensure that all users have "Full Control" Windows security permissions on the
directory where the back end is located and in the directory where the front
end is located. Also ensure that the file attributes are not set to
"Read-only."

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

 

[Guest]

Thanks camaro, I already checked and all the users have "Full Control" and
also the attributes are also not set to read only.

Dou you know how can I change the SubdatasheetName property to zero?

 

[Guest]

Thanks camaro, I already checked and all the users have "Full Control" and

also the attributes are also not set to read only.

Does this database have linked tables? If so, do the users have "Full
Control" permissions on the directory where the database file that contains
the actual tables is located?

If not, does this database have User-level security implemented? If so,
then ensure that all users have RWOP permissions on queries that are used to
update tables via the bound forms.

If not, verify the "Full Control" permissions. Have every user create a new
text file (with Notepad) in the directory where the back end is located and
save it. Open this file and add some text to it. Save the change. After
it's been saved, delete the file. The users should repeat these steps in the
directory where the front end is stored, too. If these steps are successful,
then the user has sufficient permissions to modify the database and
create/modify/delete an LDB file. If the user is prompted to "Save As" a
different file name, then the user doesn't have sufficient permissions to
modify the database file or the LDB file -- and doesn't have "Full Control"
permissions as claimed.

Dou you know how can I change the SubdatasheetName property to zero?

You may change this property to [None] for every table in the database in
the blink of an eye. Please see Allen Browne's TurnOffSubDataSh() function
on the following Web page:

http://allenbrowne.com/bug-09.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.