How To Only Read/Write-To Database Via Visual Basic Application

[clusardi2k]

I have a Visual Basic application which requires entering a user ID and
password to use the rest of the program. After entering the correct
password, the user can update the database (Only one database is ever
used) using VB. The question is what is an easy way to protect the
actual Access database. I want to only allow modification of the
database through the one VB application. The current bad behavior is
all a person has to do to change the database is double click on the
Access database without using the VM application!

Thank you,
Christopher Lusardi

 

[Cor Ligthert [MVP]]

Christopher

Not direct an AdoNet answer, however the nicest method in my idea is to use
no id and password, however use the integrated isinrole methods.

http://msdn2.microsoft.com/en-us/library/ms172996.aspx

All other methods are more clumsy in my opinion.

I hope this helps,

Cor