Admin rights after Office 2000 Service Release 1a (SR-1a)

[Jim Tinder]

I recently downloaded and installed Office 2000 Service
Release 1a (SR-1a). I have (had) a number of databases
protected with a password and internal security on the DB
objects. Following the upgrade all the DB are no longer
password protected and any attempts to modify the object
results in "not authorized" errors.

Is it simply "re-" adding a DB password or are there other
issues?

Thanks
Jim Tinder

 

['69 Camaro]

Hi, Jim.

Following the upgrade all the DB are no longer
password protected and any attempts to modify the object
results in "not authorized" errors.

Your description sounds like user-level security was applied to the
databases, but the users are now joined to the default workgroup instead of
the secured workgroup, as before the upgrade.

To make it easy, most folks stay joined to the default workgroup (so that
they don't have to enter a User ID and password every time they open an
Access database) and just use a shortcut to open the secured database with
the workgroup file so that the secure workgroup is
only used with the secured database. The syntax for such a shortcut would
be (watch out for the word wrap):

"<Full path to Office>\MSAccess.EXE" "<Full path to DB>\MyDB.MDB" /wrkgrp
"<Full path to secure workgroup>\Secure.MDW"

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)