Database Access problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
DuncanG said:
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?
Click to expand...

What error messages are you getting?

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 said:
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.
Click to expand...

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
 
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
 
DuncanG said:
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
Click to expand...

Is it an NT server? Does the problem user have RWXD permissions to the
*folder* where the mdb lives?
 
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 said:
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?
Click to expand...

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.
 
Back
Top