I use the following code to retrieve table/query permissions from an Access 97 database:

Dim doc As Document
Dim lngPerm as Long
Set doc = dbData.Containers("Tables").Documents("TableOrQueryName")
lngPerm = doc.AllPermissions

This is fine when using DAO. Does anyone know of anything similar for use when using ADO?


By the way, I noticed that my status changed recently from "Junior Member" to "Member". Why is this? Length of registration? Number of posts?

[This message has been edited by Michael (edited 07-18-1999).]