DB Tools Open Connection has problem with Read-only Access DB

[Lucy developer]

I have an access DB which is read-only.  I use Labview 7.0 DB Toolkits DBTools Open Connection.vi to open that DSN associate with that Database.  I have problem.  Error Message is below.

I have database password for Admin.  It works ok with database is read-write.  However, there are some users has read-only permission for Database access.   I am creating a tool for them to read data only. 

If database does not have password, there is no problem to open it.  However, I need to have password for security.

Error -2147467259 occurred at DB Tools Open Connec (String).vi->Get Table Field Name from DB.vi

Possible reason(s):
Exception occured in Microsoft OLE DB Provider for ODBC Drivers, [Microsoft][ODBC Microsoft Access Driver] Not a valid password..  in DB Tools Open Connec (String).vi->Get Table Field Name from DB.vi

If anyone knows how to by-pass this problem, please let me know.

Thanks,
Lucy

[Lucy developer]

I got the solution after I try several things.  When I create DSN, there is option for that DB, chose Read-only.  It solved the problem if database is read-only.

Thanks for your attention.

Lucy