User Access

[John R via AccessMonster.com]

My wife and I share a computer (XP Professional).

I have created a database that we intend to share (obviously not
simultaneously).

She cannot open it. She receives an error that says she does not have
permission.

At first I thought it was a Shared/Exclusive thing, but apparently not (have
it shared). I can't figure out why she is unable to open the database.

Any hints or solutions welcome!

 

[Ken Snell [MVP]]

Does she have read/write/delete/create rights to the folder in which the
database is located? She must have those rights in order to allow ACCESS to
create the .ldb locking information file.

 

[Larry Daugherty]

At the OS sharing level for the drive or folder on which your
application resides, the share must be for read and write.

On the hosting machine, right click the drive or folder you want to
share and click Properties then Sharing and make it available..

[not an Access problem ]

HTH

 

[John R via AccessMonster.com]

I created the database in her "My Documents" area. I did notice when looked
at the folder that it was "read only" and changed that.

So, I think I did that, but she could still not open it.

Also, she is not accessing it through a shared folder. We are using the same
machine; she has her own log in and I have my own log in. When I login on my
account, I can access the DB. When she logs in on her account, she encounters
the problem.

I will double check her rights.

-kjr

At the OS sharing level for the drive or folder on which your
application resides, the share must be for read and write.

On the hosting machine, right click the drive or folder you want to
share and click Properties then Sharing and make it available..

[not an Access problem ]

HTH

My wife and I share a computer (XP Professional).

[quoted text clipped - 8 lines]

Any hints or solutions welcome!

 

[John R via AccessMonster.com]

File and folder permissions are fine. But I am unable to open the database on
her account.

This is really bugging me!

I have other databases that I can open on the other accounts.

I created NEW databases that I can open on the other accounts.

Just this one. What the heck is it???

At the OS sharing level for the drive or folder on which your
application resides, the share must be for read and write.

On the hosting machine, right click the drive or folder you want to
share and click Properties then Sharing and make it available..

[not an Access problem ]

HTH

My wife and I share a computer (XP Professional).

[quoted text clipped - 8 lines]

Any hints or solutions welcome!

 

[John R via AccessMonster.com]

File and folder permissions are fine. But I am unable to open the database on
her account.

This is really bugging me!

I have other databases that I can open on the other accounts.

I created NEW databases that I can open on the other accounts.

Just this one. What the heck is it???

At the OS sharing level for the drive or folder on which your
application resides, the share must be for read and write.

On the hosting machine, right click the drive or folder you want to
share and click Properties then Sharing and make it available..

[not an Access problem ]

HTH

My wife and I share a computer (XP Professional).

[quoted text clipped - 8 lines]

Any hints or solutions welcome!

 

[John R via AccessMonster.com]

After puttering around with a half dozen options, I finally simply did a file
copy on the mdb file.

That worked. I can open the copy of the database on the other login.

Strange.

File and folder permissions are fine. But I am unable to open the database on
her account.

This is really bugging me!

I have other databases that I can open on the other accounts.

I created NEW databases that I can open on the other accounts.

Just this one. What the heck is it???

At the OS sharing level for the drive or folder on which your
application resides, the share must be for read and write.

[quoted text clipped - 12 lines]