MS access security warning

[Haylee]

An 'unknown publisher' security warning appears everytime I open an ms access .mdb file, if I just click 'open' I am able to open the file, however the desktop shortcuts to this file simply won't work and I have to open the database by opening ms access first then navigating to the .mdb file. Can anyone help? I run ms access 2003.

[MMcCarthy]

An 'unknown publisher' security warning appears everytime I open an ms access .mdb file, if I just click 'open' I am able to open the file, however the desktop shortcuts to this file simply won't work and I have to open the database by opening ms access first then navigating to the .mdb file. Can anyone help? I run ms access 2003.

You say the shortcut won't work. Have you tried opening the database directly at source.

This usually happens when Access is installed on a network rather than the individual machine. For some reason the machine won't recognise the file type.

You could try using the right click option Open With ... choosing the appropriate version of access and ticking the always use to open this type of file option.

[MMcCarthy]

You say the shortcut won't work. Have you tried opening the database directly at source.

This usually happens when Access is installed on a network rather than the individual machine. For some reason the machine won't recognise the file type.

You could try using the right click option Open With ... choosing the appropriate version of access and ticking the always use to open this type of file option.

Also if the database was designed in a previous version than Access 2003 you may need to convert the database to the new version even though it opens in Access 2003.

[Haylee]

Thanks. I have tried your suggestions for the shortcut by right clicking and choosing open with and selecting the 'always open with..' but it didn't help. The database was designed with and earlier version of access but has been running fine in access 2003 for months and still opens ok but its just that shortcuts don't work. would you suggest a reinstall of access to see if that resolves the problem?

[MMcCarthy]

Thanks. I have tried your suggestions for the shortcut by right clicking and choosing open with and selecting the 'always open with..' but it didn't help. The database was designed with and earlier version of access but has been running fine in access 2003 for months and still opens ok but its just that shortcuts don't work. would you suggest a reinstall of access to see if that resolves the problem?

The problem could actually lie with the security on your system. e.g. Nortons Security Features have been known to affect access databases.

Not my area of expertise, but if you think this is a possibility that this might be the problem I will try to lookup the references I've seen to it so far.