Error in sharing database

[Hollywood74]

I recently created a 2003 Access database and have placed it on a shared
network folder for multiple users to have access to it. However, when users
attempt to open the database it immediatley opens in read-only mode. I have
given all the users full permissions but it will still only open in
read-only. Any suggestions to remedy this issue would be greatly appreciated.
Thank you.

 

[Steve]

Open Windows Explorer and find your database file. Right click on the file
and click on Properties. You will see Attributes at the bottom. Look to see
if Read-Only is checked. If it is, uncheck.

Further, your post suggests that that your database is a single file and you
placed it on the network for everyone to use. If so, you need to split the
database. You need to create an MDB file that only contains the tables
(called the backend) and only put this file on the network. Then you need to
create another MDB file that contains everything in your database but the
tables called the frontend. You then need to use the LinkMaster utility to
link the frontend to the tables in the backend. Finally, you need to
distribute a copy of the frontend file to each user to install on his local
computer.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Pat Hartman \(MVP\)]

Although splitting the database is good practice and is the advised way of
sharing databases, it is not required. Access will allow multiple users to
share a database provided they are only making data modifications. If a
database is opened by more than one person, no one will be able to make
design changes to objects such as forms and reports.

It is possible that the problem with sharing the file has to do with network
permissions. Each user must have permission to create new files in the
network directory that holds the .mdb/.mde file. When the database is first
opened, Access creates an .ldb file which it uses to manage multi-user
updates. If the user who opens the database does not have permission to
create a file, Access opens the database in exclusive, read only mode.

 

[Steve]

<<Although splitting the database is good practice and is the advised way of
sharing databases, it is not required. >>

BALONEY!!!

Sooner or later a database on a network that is accessed by multiple users
will become corrupted.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)