still having a problem with READ ONLY and allowing access

[Beth McLaren]

I am still not understanding how I can make my new ACCESS 2007 database
available to my supervisor to allow her to make changes to it also. She is
only able to open it in READ ONLY. Is there a simple explanation for this or
steps in which to make this accessible to her also?
Thank you!
Beth
--

 

[John Spencer]

Is it always read-only for her or only when you have it open and she tries to
open it?

If the former, it sounds like a permissions problem on the folder where the
database resides. Your supervisor needs the ability to read, write, and
delete objects in that folder (directory).

If you are sharing the database, then you should split the database into a
backend and frontend. Backend would contain ONLY the tables and the Frontend
would contain links to the tables (not the tables) and all the other objects
in your database.

You and your supervisor would both have a copy of the front end and the
backend would be on a file server (or shared directory) so your respective
front ends could get to the data in the backend.

There is a Database Splitter option in every version of Access to split the
database into a frontend-backend configuration. I'm not sure where you find
it in 2007 (perhaps under the Office button?).

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County