Search code examples
vb.netpassword-protectionjet

vb.net database application does not work on user machine if database is password protected


In vb.net I am using password protected database with following connection string

connetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\vai\vaiDB.mdb;Jet OLEDB:Database Password=secret;"

Database access works fine on the development machine.

But when i copy the exe and the database file on the user machine


Solution

  • Opening an Access database (.MDB) creates a temporary .LDB file in the same directory. Does the user logged in to the target PC have write permissions to directory C:\vai\?