Opening access database for exclusive access

CJJ

hi Folks,

I am opening my access database file (Access 2003) from a C#
application. The connection string specifies mode=Share Exclusive

The intent is that the application have exclusive access to the
database file. No other instance of MS Access or this particular C#
application (or any other app) should be able to open the access
database file concurrently.

however it seems that this is not happening. A second instance of my
program run from another computer under another LAN user id can
successfully open a connection to the database using the same
connection string, specifying Share Exclusive.

I would appreciate any help anyone can offer.

-John

jljamison#gmail.com@NOSPAM

Jan 25 '06 #1

CJJ

never mind - i figured it out. I had inadvertently put two "Mode=..."
pairs in my connection string, the latter one was less restrictive.

Jan 25 '06 #2