Adding users without being member of Admins?

[Guest]

I am developing a turnkey database for a client. The issue is that over time my client will have to add new users to the database. The only way (that I can see) to add a new user in code is to use the .Append method on the Users collection. When this is performed by a user that is not member of the Admins group the action is denied due to lack of permission. I don't want anyone but myself (developer) to be part of the Admins group since I believe my design could be modified. My question is, how can I add users (in code) without being a member of the Admins group. Any light on this subject would be greatly appreciated. Thanks!!!

 

[Jeff Conrad]

Hi Paul,

I asked the same question last year and the very knowledgeable TC helped me
with the code.

All the details you need should be in this thread on Google:

http://tinyurl.com/25bkb

Read the entire thread for all the coding instructions.

Hope that helps,
Jeff Conrad
Access Junkie
Bend, Oregon

I am developing a turnkey database for a client. The issue is that over

time my client will have to add new users to the database. The only way
(that I can see) to add a new user in code is to use the .Append method on
the Users collection. When this is performed by a user that is not member of
the Admins group the action is denied due to lack of permission. I don't
want anyone but myself (developer) to be part of the Admins group since I
believe my design could be modified. My question is, how can I add users
(in code) without being a member of the Admins group. Any light on this
subject would be greatly appreciated. Thanks!!!

 

[Guest]

Jeff

Seems like we have the same problem! I just scanned your thread very quickly, too excited to understand the details right now, but sure looks good! I will work through it tonight

Many thanks!!
Paul

 

[Jeff Conrad]

Don't thank me, thank TC!!!
He should be stopping by pretty soon........

Jeff Conrad
Access Junkie
Bend, Oregon

Jeff!

Seems like we have the same problem! I just scanned your thread very

quickly, too excited to understand the details right now, but sure looks
good! I will work through it tonight.

 

[TC]

Thanks for the thanks, Jeff!
It's always nice to get a response.
Glad that my code worked for you.

TC

 

[Guest]

This is great gentlemen!!! I just finished importing this stuff and testing it and it works as advertised!!! I have been putting this issue on the backburner for months now
However, I am puzzled by how it works. I would have thought that by creating a Workspace object, creating users, and then wiping this workspace out that any users created would also be wiped out? I obvisouly missed something since the new users are hanging around
Once again, thank you Jeff for pointing me and thank you TC for the work you did putting this together
Pau

 

[Jeff Conrad]

Hi Paul,

This is great gentlemen!!!
I just finished importing this stuff and testing it and it works as advertised!!!

That's good!
Well of course it works, all of TC's posts come with an unlimited bumper-to-bumper
warranty.

I have been putting this issue on the backburner for months now.
However, I am puzzled by how it works. I would have thought that by creating a
Workspace object, creating users, and then wiping this workspace out that any
users created would also be wiped out? I obvisouly missed something since the
new users are hanging around.

Well I'll let TC handle the technical details, but my understanding is that once you
create the users you are adding them to the MDW file and therefore they are saved until
you remove them.
I guess an analogy would be you giving your keys to someone else for a locked door. That
person unlocks the door, they let a few people inside and then the door is closed. You
take the key back from that person, but that doesn't change the fact that the other people
are inside the room now.

Once again, thank you Jeff for pointing me and thank you TC for the work you did putting this together!
Paul

You're welcome. Glad to help.

Jeff Conrad
Access Junkie
Bend, Oregon

 

[TC]

Hi Paul,
advertised!!!

That's good!
Well of course it works, all of TC's posts come with an unlimited bumper-to-bumper
warranty.
<g>

I wish! I've come a cropper a few times, but not often

Well I'll let TC handle the technical details, but my understanding is that once you
create the users you are adding them to the MDW file and therefore they are saved until
you remove them.
I guess an analogy would be you giving your keys to someone else for a locked door. That
person unlocks the door, they let a few people inside and then the door is closed. You
take the key back from that person, but that doesn't change the fact that the other people
are inside the room now.

I couldn't have put that better. It's an excellent analogy. (Not just trying
to return the compliments!) A workspace is just a temporary, in-memory
thing. The workgroup file is a physical, semi-permanent thing. The workspace
gives access to the workgroup file. The new users are stored in the
workgroup file.

you did putting
this together!

Glad to have helped.
TC