Problem ith shared Microsoft Access File

S

sarah

Hello there
I am confused with my Microsoft Access file. I have used this Access
2003 to develop a program for our store in the office. In this simple
project, 5 persons should use this Access file for Edit and Add new
records. We use Microsoft Windows XP in our office. I have done these
jobs for this purpose:
1. I have spitted the File to Front end and back end manually.
2. I have copied the front end on the others PCs.(Clients)
3. The folder that back end file is exist on, has full control
permissions for the clients.
4. On each PC I have linked the formsto the tables on the server PC
with Linked table manager.(I mean the PC that Back end file is stored
on it)
But in this way just 1 person other than the server can edit the
records and for the others, the button for adding new records is
disabled.
How I can solve this problem? I have searched a lot and could not find
a way that solve this problem. Is it neccessary to add any codes to
the file? I am not familiar with programing in Access.
Thanks in advance.
 
A

Arvin Meyer [MVP]

Try:

Tools >>> Options >>> Advanced

Then choose:

Default Open Mode: Shared
Default Record Locking: No Locks
 
S

sarah

Thanks for the answer. But the setting is exactly same as what you
have suggested. But still just the first one who has linked to the
table have Edit permission. Some time even the first one can open the
file just in Read only mode. I don't know what to do!
 
Top