When trying to read from an Access database using the LabVIEW DB Connectivity Toolkit, I keep getting an error saying that I do not have permissions to read the table, even though the userID I wire into the DB Tools Open Connection should have full access to everything. I CAN list all the table names. I get the same result regardless of what UserID I wire, even those UserIDs that don't exist in the database or in any of the workgroup files.
Normally when opening this database using Access I use a shortcut that points to a particular workgroup file (not the one the user is noramlly joined to). My questions: 1. Any general ideas on what may be going wrong? 2. Is there any way to find out what User you are logged in as? 3. Any way to determine/specify which workgroup file you are using. I am making the connection using a File DSN. When I try to access a smiliar database in a similiar way, but one that is unsecured, I have no problems using the same code. Thanks for any help!
