skk wrote:
[Quoted Text] >
> 1. When you go through ULS, you assign a username & password but what
> if user wants to change their password later on. How can this be
> done? Or if you leave the password blank, where can user reset or
> update their password?
Via Tools, Security, Accounts...Change Password tab
> 2. After ULS is done at my desktop I wanted to simulate the production
> version so, I've copied all the necessary files to server (app.mdw,
> appBE.mdb) & shortcut, appFE.mdb to user's desktop. When user
> (listed user) tried to run the app with the shortcut (error msg
> showing my desktop path) can't open the app, even though I've
> modified the target path to new server. Did I take the right steps
> (ULS wizard at my desktop & copy files to production server (BE) &
> user's desktop (FE)) or do I copy files to production server & run
> the ULS wizard in there?
You did everything right, except that once the appBE.mdb is on the server,
you need to refresh the table links in the appFE.mdb to reflect the new
location of the tables. Tools, Database Utilities, Linked Table Manager -
put a check at the bottom and select all. When you navigate to the
appBE.mdb in its new location, use My Network Places, and it'll use the UNC
pathname.
Then copy this frontend out to the users.
> 3. If user list has to be updated (add, delete or permission) do I
> have to ran the ULS again in unsecured database and copy the new
> version to server? Also, what if user wants to update the user list
> by them self?
Users/group memberships are stored in the mdw. You can add/delete users via
Tools, security, accounts menu.
Permissions are stored in the mdb file. So if you modify any permissions,
they'd only apply to your copy of the frontend. So you'd then copy the
updated frontend to each user and overwrite their existing frontend. There
are methods to automate this updating. Tony Toews has one at
http://www.granite.ab.ca/access/autofe.htm
--
Joan Wild
Microsoft Access MVP
|