Shortcuts not working

[Maritza]

I have a few Access databases on a share drive. We are using Office 2003, with a Windos XP environment. The problem is that around 3 out of 25 users have constant problems with their shortcuts to the databases. I have created a shortcut of the databases on their Desktop and it doesn't work. We click on the database on the share drive, and it doesn't work. The only way it would work is to open access first, and opening the database from the file menu.

All computers have the same Office version and Service Pack.

Any suggestion of what to look for?

Thanks for your help,

Maritza

 

[DJkarl]

This typically happens to me if a hidden instance of Access is running in the background. Open the task manager (CTRL+ALT+DEL) then look at the Proccesses tab, look for MSACCESS.EXE, if one is there and you don't otherwise have Access open kill that process and try again.

 

[Maritza]

Hi, thanks for the reply. Unfortunately that didn't work. I found on MS Knowledge Base a few articles about this problem. Apparently is a known "Bug". One of their solutions is to add the path to open Access to your shortcut right before the path to the database. That seems to work. It opens the mde, but the users can't run the reports.

I wonder if this has something to do with missing drivers. Any ideas?

Maritza