|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Database Access problemsI have a secured database on a shared drive. All of the users in a group of
approx ten people except for one can access the database. User has created test db in same folder as have I, no problem. All points to permissions however I've gone over and over but can't find problem. I'm totally lost; can anybody suggest an area where this fault could reside? "DuncanG" <Dunc***@discussions.microsoft.com> wrote in message What error messages are you getting?news:EFFFAD9C-E842-4F1A-84EE-A94EAC2FF838@microsoft.com... >I have a secured database on a shared drive. All of the users in a group of > approx ten people except for one can access the database. > User has created test db in same folder as have I, no problem. All points > to > permissions however I've gone over and over but can't find problem. > I'm totally lost; can anybody suggest an area where this fault could > reside? > Keith. www.keithwilby.com Hmm, let me consult my crystal ball to see which of the 50 squintillion
possible error messages you are getting ... TC Apologies for slow response;
Error message Microsoft Access can't find the database file 'J:\Security\Sadmin Docs\RSCC Alarm Tests\RSCC Alarm Test Log.mdb.' As stated previously only one user can't access via shortcut. TIA "DuncanG" <Dunc***@discussions.microsoft.com> wrote in message I'm guessing that this user has different drive letter mappings than the news:C21D2A32-857A-42AA-A777-D786A379C85D@microsoft.com... > Apologies for slow response; > > Error message > > Microsoft Access can't find the database file 'J:\Security\Sadmin > Docs\RSCC > Alarm Tests\RSCC Alarm Test Log.mdb.' > > As stated previously only one user can't access via shortcut. > others, either they have no J drive or a different mapping for drive J. Regards, Keith. www.keithwilby.com User can open other shared doc in J drive. ie created at test unsecured db
located in folder on J drive and he could open it no problem Show quoteHide quote "Keith" wrote: > "DuncanG" <Dunc***@discussions.microsoft.com> wrote in message > news:C21D2A32-857A-42AA-A777-D786A379C85D@microsoft.com... > > Apologies for slow response; > > > > Error message > > > > Microsoft Access can't find the database file 'J:\Security\Sadmin > > Docs\RSCC > > Alarm Tests\RSCC Alarm Test Log.mdb.' > > > > As stated previously only one user can't access via shortcut. > > > > I'm guessing that this user has different drive letter mappings than the > others, either they have no J drive or a different mapping for drive J. > > Regards, > Keith. > www.keithwilby.com > > > "DuncanG" <Dunc***@discussions.microsoft.com> wrote in message Is it an NT server? Does the problem user have RWXD permissions to the news:21C7A533-170A-47B7-AC32-F341D08D17E1@microsoft.com... > User can open other shared doc in J drive. ie created at test unsecured db > located in folder on J drive and he could open it no problem > *folder* where the mdb lives? Keith wrote:
> "DuncanG" <Dunc***@discussions.microsoft.com> wrote in message Actually, check that *all* users have this.> news:21C7A533-170A-47B7-AC32-F341D08D17E1@microsoft.com... >> User can open other shared doc in J drive. ie created at test >> unsecured db located in folder on J drive and he could open it no >> problem > > Is it an NT server? Does the problem user have RWXD permissions to > the *folder* where the mdb lives? -- Joan Wild Microsoft Access MVP I've discovered the mapping appears to be the problem
the difference is: 'J:\Security\Sadmin Docs.................... as opposed to 'J:\Groups\Security\Sadmin Docs...................... Is there a workaround for this problem? TIA "DuncanG" <Dunc***@discussions.microsoft.com> wrote in message So the drives *are* mapped differently? I think you'll have to give the news:4410333C-186C-425F-9469-155B743C106C@microsoft.com... > I've discovered the mapping appears to be the problem > > the difference is: > > 'J:\Security\Sadmin Docs.................... as opposed to > > 'J:\Groups\Security\Sadmin Docs...................... > > Is there a workaround for this problem? > 'rogue' user their own shortcut with the correct path for them. Yes it is.
-- Show quoteHide quoteJoan Wild Microsoft Access MVP DuncanG wrote: > Is that as simple as copying and editing the current shortcut? 
Other interesting topics
Security change takes effect only locally, not on server
TC - New security model Relink tables in a secured DB - create table permission required? MDE security issue Guru's please help ... Access security model Removing Security settings Securing the Back-End Export or Import Objects from One Secured Database to Another How to control the number of installed front end files (*. mde) Locked out of all Access DBs |
|||||||||||||||||||||||
