Shared database

[Ramesh]

Hi,

I have a database file (MDB) on my assistant s PC. When I open this file in
Access in that PC, i am unable to open the same file on my PC. (2 PCs on
peer to peer) If I open the same file from my PC first, then it opens fine
on her PC too. On both PCs it is set to open in Shared mode. In both
cases, the .LDB file is created on opening.

Where could the problem be? Every time i need to use the file, i am having
to ask her to close the db, till i open it for my use. Once i open it, then
she re opens to continue her work.

Could anyone help me save this pain please?

Thanks
Ramesh

 

[Joseph Meehan]

Hi,

I have a database file (MDB) on my assistant s PC. When I open this
file in Access in that PC, i am unable to open the same file on my
PC. (2 PCs on peer to peer) If I open the same file from my PC
first, then it opens fine on her PC too. On both PCs it is set to
open in Shared mode. In both cases, the .LDB file is created on
opening.
Where could the problem be? Every time i need to use the file, i am
having to ask her to close the db, till i open it for my use. Once i
open it, then she re opens to continue her work.

Could anyone help me save this pain please?

Thanks
Ramesh

I don't have an answer to your specific problem, but I would offer a
couple of general observations.

1. Access does not like marginal networks and peer to peer is usually
marginal.
2. Shared databases are almost always happier if they are split with a
front end linked to the "back end" database rather than sharing the same
database.

 

[Susie DBA [MSFT]]

stop blaming everything on the network, dipshit!

it's not the networks fault-- it is Access MDB

Access works great across all networks, ADP works great over VPN,
Wireless and WAN

Access MDB is for cripples and retards--
Access MDB should only be used by homeless people

 

[Tony Toews [MVP]]

stop blaming everything on the network, dip****!

it's not the networks fault-- it is Access MDB

Access works great across all networks, ADP works great over VPN,
Wireless and WAN

Access MDB is for cripples and retards--
Access MDB should only be used by homeless people

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Joseph Meehan]

stop blaming everything on the network, dipshit!

it's not the networks fault-- it is Access MDB

Aaron, why do you keep posting under different names. Everyone really
knows who you are.

Sorry about Aaron - you get all types in a public forum!!

 

[Ramesh]

Hi tony,

am not sure i get what this means. does it mean there is something that can
be fixed in my setup or there is no way out?

Thanks
Ramesh

 

[David W. Fenton]

am not sure i get what this means. does it mean there is
something that can be fixed in my setup or there is no way out?

What Aaron posted MEANS NOTHING. It's just disinformation, designed
to provoke the regulars in the newsgroup.

Ignore it.

It is not helpful information at all.

 

[Tony Toews [MVP]]

I have a database file (MDB) on my assistant s PC. When I open this
file in Access in that PC, i am unable to open the same file on my
PC. (2 PCs on peer to peer) If I open the same file from my PC
first, then it opens fine on her PC too. On both PCs it is set to
open in Shared mode. In both cases, the .LDB file is created on
opening.
Where could the problem be? Every time i need to use the file, i am
having to ask her to close the db, till i open it for my use. Once i
open it, then she re opens to continue her work.

This sounds like a permissions problem.

This is probably a permissions problem on the directory in which the backend is
installed. The users must have create/delete privileges to that directory. What is
happening is that Access can't create the .ldb file which allows multiple users to
update the MDB. So Access only allows one user at a time.

One simple way of testing this is to ensure the users can create and delete a file in
the network share. Any file, even using notepad, is enough to test this. I simply
don't trust all those permissions screen within the OS. You never quite know whats
lurking behind the advanced button. So test this yourself.

Sometimes it could only be one user who does not have create privileges to cause
problems who just happens to be the first user into the MDB at that moment in time.
Then all the other Access users can't access the file because the first user is in
exclusively.

"I found that I could keep the permissions set to Change, but had to ensure that the
directory in which the db resides was set to not inherit permissions from it's
parent. It seemed that every time a new user logged onto a given machine, it got
messed up."

See ACC: Determining Which User Has Opened Database Exclusively (Q169648)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q169648
Essentially you must use tools on the server to determine who has locked the file.

For MS info see ACC: Introduction to .ldb Files (95/97) [Q136128]. Or the version
appropriate for your version of Access.'

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tom Wickerath MDB]

sounds to me like you haven't analyzed your database needs

Access MDB is a file-based database

if you care enough about your data to make a database; you really should
consider using a database SERVER such as MSDE or SQL Server

I have a database file (MDB) on my assistant s PC. When I open this
file in Access in that PC, i am unable to open the same file on my
PC. (2 PCs on peer to peer) If I open the same file from my PC
first, then it opens fine on her PC too. On both PCs it is set to
open in Shared mode. In both cases, the .LDB file is created on
opening.
Where could the problem be? Every time i need to use the file, i am
having to ask her to close the db, till i open it for my use. Once i
open it, then she re opens to continue her work.

This sounds like a permissions problem.

This is probably a permissions problem on the directory in which the
backend is
installed. The users must have create/delete privileges to that
directory. What is
happening is that Access can't create the .ldb file which allows multiple
users to
update the MDB. So Access only allows one user at a time.

One simple way of testing this is to ensure the users can create and
delete a file in
the network share. Any file, even using notepad, is enough to test this.
I simply
don't trust all those permissions screen within the OS. You never quite
know whats
lurking behind the advanced button. So test this yourself.

Sometimes it could only be one user who does not have create privileges to
cause
problems who just happens to be the first user into the MDB at that moment
in time.
Then all the other Access users can't access the file because the first
user is in
exclusively.

"I found that I could keep the permissions set to Change, but had to
ensure that the
directory in which the db resides was set to not inherit permissions from
it's
parent. It seemed that every time a new user logged onto a given machine,
it got
messed up."

See ACC: Determining Which User Has Opened Database Exclusively (Q169648)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q169648
Essentially you must use tools on the server to determine who has locked
the file.

For MS info see ACC: Introduction to .ldb Files (95/97) [Q136128]. Or the
version
appropriate for your version of Access.'

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

['69 Camaro]

Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Tom would never post such a message.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

sounds to me like you haven't analyzed your database needs

Access MDB is a file-based database

if you care enough about your data to make a database; you really should
consider using a database SERVER such as MSDE or SQL Server

I have a database file (MDB) on my assistant s PC. When I open this
file in Access in that PC, i am unable to open the same file on my
PC. (2 PCs on peer to peer) If I open the same file from my PC
first, then it opens fine on her PC too. On both PCs it is set to
open in Shared mode. In both cases, the .LDB file is created on
opening.
Where could the problem be? Every time i need to use the file, i am
having to ask her to close the db, till i open it for my use. Once i
open it, then she re opens to continue her work.

This sounds like a permissions problem.

This is probably a permissions problem on the directory in which the
backend is
installed. The users must have create/delete privileges to that
directory. What is
happening is that Access can't create the .ldb file which allows multiple
users to
update the MDB. So Access only allows one user at a time.

One simple way of testing this is to ensure the users can create and
delete a file in
the network share. Any file, even using notepad, is enough to test
this. I simply
don't trust all those permissions screen within the OS. You never quite
know whats
lurking behind the advanced button. So test this yourself.

Sometimes it could only be one user who does not have create privileges
to cause
problems who just happens to be the first user into the MDB at that
moment in time.
Then all the other Access users can't access the file because the first
user is in
exclusively.

"I found that I could keep the permissions set to Change, but had to
ensure that the
directory in which the db resides was set to not inherit permissions from
it's
parent. It seemed that every time a new user logged onto a given
machine, it got
messed up."

See ACC: Determining Which User Has Opened Database Exclusively (Q169648)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q169648
Essentially you must use tools on the server to determine who has locked
the file.

For MS info see ACC: Introduction to .ldb Files (95/97) [Q136128]. Or
the version
appropriate for your version of Access.'

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Long Live Aaron Kempf]

sounds to me like a reliability problem

if your database craps out then find a real database

I have a database file (MDB) on my assistant s PC. When I open this
file in Access in that PC, i am unable to open the same file on my
PC. (2 PCs on peer to peer) If I open the same file from my PC
first, then it opens fine on her PC too. On both PCs it is set to
open in Shared mode. In both cases, the .LDB file is created on
opening.
Where could the problem be? Every time i need to use the file, i am
having to ask her to close the db, till i open it for my use. Once i
open it, then she re opens to continue her work.

This sounds like a permissions problem.

This is probably a permissions problem on the directory in which the
backend is
installed. The users must have create/delete privileges to that
directory. What is
happening is that Access can't create the .ldb file which allows multiple
users to
update the MDB. So Access only allows one user at a time.

One simple way of testing this is to ensure the users can create and
delete a file in
the network share. Any file, even using notepad, is enough to test this.
I simply
don't trust all those permissions screen within the OS. You never quite
know whats
lurking behind the advanced button. So test this yourself.

Sometimes it could only be one user who does not have create privileges to
cause
problems who just happens to be the first user into the MDB at that moment
in time.
Then all the other Access users can't access the file because the first
user is in
exclusively.

"I found that I could keep the permissions set to Change, but had to
ensure that the
directory in which the db resides was set to not inherit permissions from
it's
parent. It seemed that every time a new user logged onto a given machine,
it got
messed up."

See ACC: Determining Which User Has Opened Database Exclusively (Q169648)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q169648
Essentially you must use tools on the server to determine who has locked
the file.

For MS info see ACC: Introduction to .ldb Files (95/97) [Q136128]. Or the
version
appropriate for your version of Access.'

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/