Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I track users who access a spreadsheet? | Excel Discussion (Misc queries) | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Multi users and linking to Access | Excel Discussion (Misc queries) | |||
Users database question | Excel Discussion (Misc queries) | |||
Access with different users | Excel Worksheet Functions |