User accounts, their PIDs and methods of creating them

G

Guest

When deleting a user from Access using the Tools menu,
Security, User and Group Accounts... method a MsgBox
indicates that you cannot restore a user (or group)
account unless you use the same user (or group) name and
PID (or GID). What does restore actually mean? I can
delete a user and then create a new user with the same
name but a different PID. Will this cause any problems?

I have the VBA code to add users to a workgroup with both
the ADOX and DAO methods. Using DAO the code I can
provide the PID but with ADOX code I cannot. I assume the
ADOX method assigns a PID. How can it be obtained? What
happens if you delete a user name and then create the same
one again using the ADOX method? Will a different PID be
used?

I have read the code in this Newsgroup that uses a ADODB
connection and executes a CREATE USER command to add a
user with their PID. I assume this means another Library
has to be added to the References.. list. (Which leads to
another question... Does an increase in the number of
reference libraries included slow down the application?)

What method is best? Does it matter if you mix methods?
Which method will be supported longest?


C Monsour
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top