Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / September 2005

Tip: Looking for answers? Try searching our database.

User Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John R - 23 Sep 2005 02:35 GMT
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] - 23 Sep 2005 03:08 GMT
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.

Signature

       Ken Snell
<MS ACCESS MVP>

> My wife and I share a computer (XP Professional).
>
[quoted text clipped - 9 lines]
>
> Any hints or solutions welcome!
Larry Daugherty - 23 Sep 2005 05:13 GMT
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
Signature

-Larry-
--

> My wife and I share a computer (XP Professional).
>
[quoted text clipped - 8 lines]
>
> Any hints or solutions welcome!

http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200509/1
John R - 23 Sep 2005 19:11 GMT
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.
[quoted text clipped - 12 lines]
>
>http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200509/1
John R - 24 Sep 2005 00:14 GMT
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]
>
>http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200509/1
John R - 24 Sep 2005 00:14 GMT
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]
>
>http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200509/1
John R - 24 Sep 2005 01:01 GMT
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.
[quoted text clipped - 12 lines]
>>
>>http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200509/1
 
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.