Database Access problems

[DuncanG]

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]

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?

What error messages are you getting?

Keith.
www.keithwilby.com

 

[TC]

Hmm, let me consult my crystal ball to see which of the 50 squintillion
possible error messages you are getting ...

TC

 

[DuncanG]

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

 

[Keith]

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]

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

 

[Keith]

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?

 

[DuncanG]

Yes to both questions

 

[Joan Wild]

Is it an NT server? Does the problem user have RWXD permissions to
the *folder* where the mdb lives?

Actually, check that *all* users have this.

 

[DuncanG]

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

 

[Keith]

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?

So the drives *are* mapped differently? I think you'll have to give the
'rogue' user their own shortcut with the correct path for them.

 

[DuncanG]

Is that as simple as copying and editing the current shortcut?

 

[Joan Wild]

Yes it is.

 

[DuncanG]

Hopefully this will be the solution.