Paradox
August 17th, 2001, 03:13 PM
Hi all,
I've a few posts in here at once, but they've become very frsutrating to face on a Friday afternoon, so perhaps there's a guru somewhere who can help me out.
I'm new to VB, and not entirely sure of it's capabilities, but I would like to know if there's a way to programmatically determine who "owns" a database in access.
IE, you can go through the menus inside access, tools -> Security ->.. yada yada. But is there a properties or function call which might grab this information directly? I'm dealing with roughly 100 + databases (not of my design), and it would be helpful if I could obtain a list of the people I'll need to contact/log in as before I can make any code changes.
String = db.properties.owner 'That kinda thing.
Or if there is a way to bypass the "ownership" alogether via an admin account. I've tried twice already, with permissions, but unfortunatly, access isn't as sensical as we would imagine it to be.
Anyway, that's my novel.
Comment, share, suggest. Thanks everyone.
Wes.
I've a few posts in here at once, but they've become very frsutrating to face on a Friday afternoon, so perhaps there's a guru somewhere who can help me out.
I'm new to VB, and not entirely sure of it's capabilities, but I would like to know if there's a way to programmatically determine who "owns" a database in access.
IE, you can go through the menus inside access, tools -> Security ->.. yada yada. But is there a properties or function call which might grab this information directly? I'm dealing with roughly 100 + databases (not of my design), and it would be helpful if I could obtain a list of the people I'll need to contact/log in as before I can make any code changes.
String = db.properties.owner 'That kinda thing.
Or if there is a way to bypass the "ownership" alogether via an admin account. I've tried twice already, with permissions, but unfortunatly, access isn't as sensical as we would imagine it to be.
Anyway, that's my novel.
Comment, share, suggest. Thanks everyone.
Wes.