Access 2003 Custom Security Reports

[Guest]

Does anyone know how I can create a report showing all users and groups and
permissions in a workgroup file? support.microsoft.com has a kb article
#208789 with code that allows you to create custom security reports. The
problem is that the code does not work. Using this code results in a type
mismatch at "Set UsrRs=Secdb.OpenRecordset("UTL_UsrTable"). If anyone could
be of some help I would really appreciate it.

 

['69 Camaro]

Hi, Ryan.

Your database's ADO library reference is interfering. You need to
disambiguate the Recordset object in order to use this code. Please see Tom
Wickerath's tip, "DAO Library Reference in Access Databases" on the
following Web page:

http://www.Access.QBuilt.com/html/gem_tips1.html

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.)