470,864 Members | 1,834 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,864 developers. It's quick & easy.

Opening access database for exclusive access

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.



Jan 25 '06 #1
1 3468
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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Jan Szymczuk | last post: by
18 posts views Thread by Andre Laplume via AccessMonster.com | last post: by
reply views Thread by MSDN | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.