 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / March 2007Sharing an open database
Hi, I have a few databases on a shared folder on a system A. They are set to operate in Shared mode. But i have any of them open in system A, i am unable to open it from another system B on the network. However if i first open the database from the system B, then i am also able to open it on System A. Is this the only way it works or have i done something wrong somewhere? I d like an open database to be sharable no matter which system it is opened from. Any advice please? Thanks Ramesh Hi, Depends what you are doing in the database. If you start to edit anything in the database (excluding recrods) the database will switch to exclusive mode. This is the only reason i can think of why this would happen. Also i would suggest in a multi user/computer situation, splitting your database. This means that te server db just hold the tables and the client machines each have a db with everything (forms, queries, reports) else, and links to the tables in the db on the server. This allows for much more flexibility when making changes and is also better for many other reasons. Search this forum or google for splitting databases, for lots of info. HTH > Hi, > [quoted text clipped - 13 lines] > Thanks > Ramesh rico, this happens even if i do nothing other than just open the DB on system A and then try to do the same on system B. My scenario is just a 2 system network, between my assistant and me. would data splitting still be a good idea? Thanks ramesh > Hi, > [quoted text clipped - 33 lines] >> Thanks >> Ramesh Check the Network Rights for the users logged into each system. Actually check them. Don't just assume they are the same. In particular, both users MUST have CREATE, DELETE, and MODIFY rights to the *folder* where the MDB file exists. Here's what typically happens. When you the first user opens the database in shared mode, an LDB (locking file) is created. When you open a database in Exclusive mode, no LDB is created. When someone else tries to open the database, Access looks to see if 1) the database is already open and 2) if there's an LDB. If the database is open and there is no LDB, then it knows the database is opened exclusively. Now back to the Rights issue. When a user who does not have CREATE rights to the *folder* opens the database, no LDB file is created. Therefore even if it was opened in Shared mode, Access thinks it was opened Exclusively and therefore no one else can open it.  Signature--Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L > Hi, > [quoted text clipped - 13 lines] > Thanks > Ramesh thanks Roger for your very descriptive response. still am stuck cos in both cases i am logging as administrator. and in both cases, the LDB is getting created. but only in one case, am unable to share. there is no response whatsover when i double click the DB file. No error message either. However one thing i notice is that the LDB file is left behind even after i close the DB. does that give any clue to teh problem? Thanks for your inputs. Ramesh > Check the Network Rights for the users logged into each system. Actually > check them. Don't just assume they are the same. In particular, both [quoted text clipped - 30 lines] >> Thanks >> Ramesh Actually, this sounds like an altogether different problem. I ran into this when my place upgraded to Access 2003. See if the Symptoms in this knowledgebase article: http://support.microsoft.com/?id=303650 match yours and try the suggested solutions. Also, the fact that the LDB is not deleted suggests that you don't have DELETE rights to the folder. Make sure you are give ALL rights to the folder. Signature--Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L > thanks Roger for your very descriptive response. > [quoted text clipped - 43 lines] >>> Thanks >>> Ramesh am very sorry Roger, i slipped on your mesg al these days. jsut saw it, checked out the link .. the scenario there doesnt match. and i am still managing with the problem. whenever i want to access the db on that system, i need to ask the first user to close! no problem with delete rights. am able to delete other files. Ramesh > Actually, this sounds like an altogether different problem. I ran into > this when my place upgraded to Access 2003. See if the Symptoms in this [quoted text clipped - 52 lines] >>>> Thanks >>>> Ramesh But does the other user have Create, Modify, and Delete rights? That's the real issue. Signature--Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L > am very sorry Roger, i slipped on your mesg al these days. jsut saw it, > checked out the link .. the scenario there doesnt match. [quoted text clipped - 63 lines] >>>>> Thanks >>>>> Ramesh |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.