access read only problem

[deepak]

Hi ,
i created a access data base .. which some other user must clear the data in
the table .. when the other user is opening the db its opening as read-only
file .. can anyone help me how to get over that ?.. thanks

 

[Jeanette Cunningham]

All data editing must be done through forms. No users can open any tables or
queries, it is all done using forms.
Split the database into a backend and frontend. Give each user a copy of the
frontend on their computer and link the frontends back to the only copy of
the backend on the server.
This is the only yaw you can fix your problem.

Jeanette Cunningham

 

[Tom van Stiphout]

On Fri, 25 Jan 2008 07:16:07 +1100, "Jeanette Cunningham"

This is all good advice, but the underlying problem may be that the
Windows permissions for the shared folder are set too restrictive. All
users must have the ability to create files in the folder, such as the
..ldb file.

-Tom.