users and DAO with access database
 

I have a VBA routine that creates an Access database...easy enough. What
I'm wondering is if you can create users and permissions for the database
via VBA. I've searched the NGs and the MS KB but haven't found anything.
MS Access is not available so I'm using Excel as the front-end.

TIA

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winne the Pooh

users and DAO with access database
 

I'm always boasting here that you can create Jet databases without the
MS Access app, but you're asking difficult questions now! Happily, I
think your needs can be fulfilled using ADOX:

Using ADO to Work with Access[sic] Databases
http://msdn.microsoft.com/library/de...sdatabases.asp

"ADOX also lets you create and modify user and group accounts for
databases secured with user-level security, and grant and revoke
permissions on objects"

Eeyo We can't all, and some of us don't. That's all there is.

--

"Michael Malinsky" wrote in message ...
I have a VBA routine that creates an Access database...easy enough. What
I'm wondering is if you can create users and permissions for the database
via VBA. I've searched the NGs and the MS KB but haven't found anything.
MS Access is not available so I'm using Excel as the front-end.

TIA
"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winne the Pooh