Password problem

[FF]

After installing Visual Basic .Net 2003, I am having trouble connecting to
an Access database.



I use a dataadapter and the Querybuilder with a Jet 4.0 OLE DB provider and
everything works fine until I press the finish button, then I get the error
message: "Format of initialization string does not conform to OLE DB
specification". Then it asks for a password, but the database is not
protected with a password.



The connection string is:

Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet
OLEDBatabase Locking Mode=1;Jet OLEDBatabase Password=;Data
Source="C:\Documents and Settings\FrankF\My
Documents\Databaser\2003\NyBad\Bad.mdb";Password=;Jet OLEDB:Engine
Type=5;Jet OLEDB:Global Bulk
Transactions=1;Provider="Microsoft.Jet.OLEDB.4.0";Jet OLEDB:System
database=;Jet OLEDB:SFP=False;Extended Properties=;Mode="ReadWrite|Share
Deny None";Jet OLEDB:New Database Password=;Jet OLEDB:Create System
Database=False;Jet OLEDBon't Copy Locale on Compact=False;Jet
OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt
Database=False



Thanks in advance

Frank

 

[Joe Fallon]

Try this:
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strLocalFileName

 

[FF]

The problem arises if you make your connection read/write