Sharing an open database

R

Ramesh

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
 
R

rico

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
 
R

Roger Carlson

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.


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

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
 
R

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
 
R

Roger Carlson

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.

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

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
 
Top