Prohibiting Shortcuts from being Created

[SuzanneBBI]

This isn't truly an Access question....but...how can I prohibit users from creating shortcuts of databases that are on shared drives? They think they know how to do it, but wind up putting actual copies on their desktops. You can imagine the grief this causes!! Any ideas?

 

[Databaseguy]

First, search and destroy all desktop copies.

Then, in your autoexec macro, add a run code statement that points to a global module.

In the module, type something like

Public Sub CheckRemote()
Dim dbsCurrent As Database
Set dbs = CurrentDb
If dbs.Name <> &quot;your remote database path and file&quot; Then
MsgBox &quot;Please see IT for instructions on how to properly create a shortcut !!&quot;
DoCmd.Quit
Else
End If

End Sub Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[SuzanneBBI]

DatabaseGuy: THANKS so much! I will give this a shot later today!