Error when trying to open secured mdb

[Barry Schwartz]

When I try to open an mdb (using a shortcut that call's
the relevant mdw), I get the following error message:

"Microsoft Access can't find the database
file '<filename>'.

Make sure you entered the correct path and file name."

This is on a new Win XP SP1 machine that I have set up
for 2 users. The mdb opens fine for the user with which
I create the folder and move the mdb into, but won't for
the other user. Even if I try clicking directly on the
mdb (without using the shortcut that links to the mdw) I
get the above message, not the one I'd expect about not
having the correct permissions.

Both users are set up as Administrators. I have created
an unsecured mdb and this opens fine for both users. I
get the same scenario regardless of which user I set up
first.

 

[Raghu Prakash]

Hi Barry,

SYMPTOMS
When you click a shortcut to an existing Microsoft Access database, you
receive the following error message:

Can't find database specified or you didn't specify a database at all.
Specify a valid database name in the command line and include a path if
necessary.
CAUSE
This behavior can occur if either of the following is true:
The shortcut points to an earlier version of the Access run-time
application, and you chose to remove earlier Office programs during Setup.

-or-
Norton Anti-Virus was installed when you installed Access 2002.
RESOLUTION
To resolve the shortcut issue, follow these steps:
Remove Access 2002.
Reinstall the Access run-time application.
Verify that you can use the shortcut to open the database.
Reinstall Access 2002, and select not to upgrade existing versions of
Office.
To resolve the issue where Norton Anti-Virus was installed, follow these
steps:
Remove Access 2002.
Remove Norton Anti-Virus.
Reinstall Access 2002.
Verify that you can use the shortcut to open the database.
Reinstall Norton Anti-virus.
If neither of these methods resolves the issue, you must manually create a
new shortcut. You must include the path to the correct version of
Msaccess.exe and the path and file name of the database that you want to
open. For example, in the Target section of the shortcut properties, enter
something similar to the following:
"C:\Program Files\Microsoft Office\Office10\msaccess.exe" "C:\My
Documents\mymdb.mdb"

For Further Information :Microsoft Knowledge Base Article - 304067

Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.