Microsoft Access 2000 - Shortcuts not working for 1 user

[Andrew Gordon]

Hi

I hope that someone out there can help me with this issue as I am now at my
wits end.

We have one user who cannot open Microsoft Access databases either by double
clicking on a shortcut or by double clicking on the database file itself.
The only way they can currently open an Access database is by opening MS
Access and then opening the database from with there.

The error received is "Windows cannot access the specified device, path or
file. You may not have the appropriate permissions to access the item."

So far I have checked the users profile looks correct and deleted it and
then logged back on so it was reloaded afresh. I've checked and tried
various permissions on the Microsoft Office directories in case the user was
not being allowed access to MSACCESS.EXE. I've copied the first part of the
shortcut which is "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
and pasted it into a Run command and Access opened Ok. When I paste the
full shortcut into a Run command that didn't work (the database uses an mdw
file so the full shortcut is quite long). I have also checked the settings
on Internet Explorer 7 as I read that a particular setting may have been
changed by one of the updates. There are no errors relating to this in the
Event Viewer.

None of these attempts have been successful and I'm not sure what else to
do. As mentioned the user can open the databases through Access itself but
I'm concerned this may be a symptom of a more serious problem and also that
it may spread to other users.

For further info we use Windows 2003 server and MS Office 2000 Professional.
The user has informed me that they logged on and worked in a non-TS
environment yesterday and asked if that could have affected things but I
cannot see how it would do so. I have checked Active Directory and the
Terminal Server Profile is in a different location than the normal profile.

If anyone can provide assistance on where to go next I'll really appreciate
your help.


Many thanks in advance

Andrew Gordon
nospam.#[email protected]#.nospam.com

 

[Stefan Hoffmann]

hi Andrew,

The error received is "Windows cannot access the specified device, path or
file. You may not have the appropriate permissions to access the item."

Use ProcessMonitor from sysinternals.com. It can show you failing file
and registry access.

For further info we use Windows 2003 server and MS Office 2000 Professional.
The user has informed me that they logged on and worked in a non-TS
environment

What is your normal setup here?


mfG
--> stefan <--

 

[Andrew Gordon]

Hi again

Further info I've just found is that if I create a new blank database and
save it to the Terminal Servers local disk then I canb open it by double
clicking on the file as would normally be expected. If I create a blank
database on a network drive and try the same thing I get the same error
again.

Thanks

Andrew

__________________________________________________________

 

[Andrew Gordon]

Hi Stefan and thank you for your quick response.

I've downloaded and opened this program although there are 20 users on the
Terminal Server at the moment so it's very hard for me to see what is what.
My plan is to try again using this tool tonight as there will be nobody else
to confuse things. This could be more a case of me not knowing how to use
the tool properly of course.

In answer to your question about our normal setup, we normal work over
Terminal Services and that has been the case for a few years now. Prior to
that we were all fat clients.

Best regards,

Andrew

____________________

 

[Stefan Hoffmann]

hi Andrew,

Further info I've just found is that if I create a new blank database and
save it to the Terminal Servers local disk then I canb open it by double
clicking on the file as would normally be expected. If I create a blank
database on a network drive and try the same thing I get the same error
again.

Sounds like security. Compare the alternate data streams. Maybe it is
the zone identifier.


mfG
--> stefan <--

 

[Andrew Gordon]

Hi Stefan

Thank you very much, I'll look into that and keep you posted.

Cheers

Andrew

_____________________________________

 

[Andrew Gordon]

Hi

Firstly, big thank you Stefan for your responses and help.

I've titled the message resolution but really it's a workaround where I
deleted all copies of the users TS profile apart from the original (I
renamed that). I logged the user on which created a brand new profile and
this resolved the issue. Copied the desktop icons, favourites etc over to
the new profile and all is well.

It's very strange so I am likely to recreate the situation and try Stefan's
suggestions but perhaps not tonight. If I find any solutions I'll post them
here.

Thanks

Andrew