Connecting Tech Pros Worldwide Forums | Help | Site Map

Connecting Access 2003

Newbie
 
Join Date: Jul 2008
Posts: 1
#1: Aug 19 '08
I am developing an application in vb2005 with Access 2003 which is protected with password. I am using OLEDB Connection and command. whenever i try to connect with the database an error occures saying " Cannot start your apploication, Workgroup Information file is missing or opened exclusively by another user"
Problem is with Connection String
Below is the code for Connection String to connect with the Database,


dim ConnectionString as String = "Provider = Microsoft.Jet.oledb.4.0 ; Data Source = E:\mydatabase.mdb ; Password = 123"


I have also tried the following code but failed;

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet
OLEDB:Database Password=MyDbPassword"

any body help.

I have visisted many forums but failed.

Reply