access database "current user"

[j_a]

I need some help with user credentials when using the Database Connectivity toolkit to interface with an Access database file. There are users and groups defined in a workgroup. Using a file DSN I am able to read and write to tables in the Access databse file. However, I have absolutely no idea how to "extract" user names from the .mdw file. Any help is appreciated. Thanks.

[Dennis_Knutson]

Are you the admin? If you are not, then you need to get a valid user and password from the admin or ask for one to be created with the necessary rights.

[j_a]

Not sure if I explained it properly or I may be misunderstanding your reply. I have the proper credentials to read and write to the tables of the .mdb file. So no problems there as far as rights.

What I intended to do was get valid user names from the .mdw file and populate a ring control so that users can select from a list instead of typing in their credentials.

[Aldo_A]

Hi j_a,

The biggest hurdle that we are going to face is the .mdw file structure/format. Although there is no VI which directly reads the file, I think one of the work-arounds is to convert the file to text which then you can parse the usernames to populate your control. The encryption of the file will prevent any conversion using notepad/wordpad so we are going to need a third-party converter. 

[j_a]

Thanks. That's what I was afraid of. For now I will put this on hold on move on to a different approach.