Basically, all that needs to be done to have the system prompt for a user name and password when opening the database is modify the target path in the desktop shortcut. The target path needs to include the path of the Microsoft Access executable (MSACCESS.EXE), the Catalyst front-end database, and the workgroup switch. For detailed instructions on how to modify the desktop shortcut, please refer to the Modifying Desktop Shortcut help topic.
Note: When modifying the desktop shortcut to prompt for user login, the Catalyst workgroup file (Catalyst.mdw) needs to be moved to a shared folder on the server. Please refer to the help topic regarding 'Enabling User Level Security' for more information.
0 Comments