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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|