Exclusive Connection to Access Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
How do I set the connectionstring to get Exclusive connection to MS Access
database. I want to let the user reset the database password.

Thanks,
Debi
 
Debi said:
Hi,
How do I set the connectionstring to get Exclusive connection to MS Access
database. I want to let the user reset the database password.

Thanks,
Debi
Click to expand...

Try this:

Driver={Microsoft Access
Driver(*.mdb)};Dbq=DBFilePath.mdb;Exclusive=1;Uid=admin;Pwd="

I would recommend www.connectionstrings.com for any connection string
questions you may have, they have an exhaustive list of strings to connect to
just about any data source there is.

Hope this helps,

Keith
 
It looks like you will need to set the following parameter:

Jet OLEDB:Connection Control = 1.

HTH,

Keith
 
Any idea on where to set it? I put that in connection string and it threw an
error. The sample given in microsoft site shows vb code not .net.

Thanks,
Debi
 
Debi,
Any idea on where to set it? I put that in connection string and it threw
an
error. The sample given in microsoft site shows vb code not .net.
Click to expand...
I assume that you mean DAO, ADODB or something like that.

Probably the only way to do things as you do now.

Do not forget that ADONET is completely based on a disconnected environment.

I hope this helps,

Cor
 
¤ Hi,
¤ How do I set the connectionstring to get Exclusive connection to MS Access
¤ database. I want to let the user reset the database password.

Try adding "Mode=Share Exclusive;" to your OLEDB connection string.


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top