A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

still having a problem with READ ONLY and allowing access



 
 
Thread Tools Display Modes
  #1  
Old July 17th, 2009, 02:15 PM posted to microsoft.public.access.gettingstarted
Beth McLaren
external usenet poster
 
Posts: 17
Default still having a problem with READ ONLY and allowing access

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
--

  #2  
Old July 17th, 2009, 02:34 PM posted to microsoft.public.access.gettingstarted
John Spencer
external usenet poster
 
Posts: 7,815
Default still having a problem with READ ONLY and allowing access

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

Beth McLaren wrote:
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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:14 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.