change the location of Access

[tconlon]

Hi folks. I'm trying to change the location of the Access mdb file I
connect to using OleDb and am having trouble. I'm using Visual C# 2005

and the default values I use for the ConnectionStrin g are those
generated by the Server Explorer. I can connect just fine using the
default values.

But when I comment out strDefaultConne ctionFile and uncomment the
dbName variable I get:
'OleDbException : Could not use "; file already in use.' During testing

I select the exact same path and file that are used in the default, and

I have confirmed this by copying both 'runtime' strings to a text file
and comparing them.
So the two strings are identical. But the 2nd fails. Of course, I
close the debugger when switching between strings and have confirmed
that there are no locks on the database. And access permissions are
the same for the mdb in both cases. I am baffled!
Code fragments are below. Any help would be appreciated.

//Three strings defined earlier in the code...
strDefaultConne ctionPre =
"Provider=Micro soft.Jet.OLEDB. 4.0;Password="" "";User ID=Admin;Data
Source=";

strDefaultConne ctionFile = @"C:\Program Files\HID\Confi g
Card Production Utility\ConfigC ard.mdb";

strDefaultConne ctionPost = @";Mode=ReadWri te|Share Deny
None;Extended Properties="""" ;Jet OLEDB:System database="""";J et
OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";J et
OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global
Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1; Jet OLEDB:New
Database Password="""";J et OLEDB:Create System Database=False; Jet
OLEDB:Encrypt Database=False; Jet OLEDB:Don't Copy Locale on
Compact=False;J et OLEDB:Compact Without Replica Repair=False;Je t
OLEDB:SFP=False ";

//Code fragment of a method called to define the data
source at runtime...

if (openFileDialog 1.ShowDialog() == DialogResult.OK )
{
if ((testStream = openFileDialog1 .OpenFile()) == null)
{
testStream.Clos e();
return false;
}
//Install the new path and test it.
dbName = openFileDialog1 .FileName;
oleDbConnection 1.ConnectionStr ing =
strDefaultConne ctionPre +
// @dbName +

strDefaultConne ctionFile +

strDefaultConne ctionPost;
if (!TestConnectio n())
{
return false;
}
}
else
return false;