First, I apologize upfront. I originally posted this question within another post that covered different but related topics. It occurred to me that this forum may be more appropriate for this question. Not trying to be repetitive.
My question is this.
I have a form that I use to create user accounts in a database saved in a 2003 file format. I can add and remove users as well as assign and remove groups. Everything works fine with one exception. I have two list boxes. One shows all current user accounts and the other shows all current groups. As a user or group is rerated, I need both of these list boxes to be updated and reflect the new additions (or removals).
However, the only way that I can get this to work is to close the entire database and reopen it. My thought is that the dbengine.workspace needs to be requeried.
Is this the case? If so, how do you do that?