Groups > Databases > Access Databases and AccessDataSource Control > Re: Access Database and locks




Access Database and locks

Access Database and locks
Wed, 19 Mar 2008 18:42:26 +000
Hello, 

If I put a lock on an access database.  How do I send the password to unlock the
database? Is this some how supplied via a connection statement?

Public MyPath AsString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA
SOURCE=\\pathtodatabase\DatabaseName_be.mdb"

 Thanks
Post Reply
Re: Access Database and locks
Wed, 19 Mar 2008 20:11:41 +000
What kind of "lock" are you talking about?  Do you mean you
password-protect the database?  If so, you do indeed add properties to the
connection string to pass the user name and password.  Scroll about half way
down: http://www.connectionstrings.com/?carrier=access
Post Reply
Re: Access Database and locks
Thu, 20 Mar 2008 16:15:21 +000
It's funny, when I woke up this morning I thought about the post, and that is
exactly what i meant to say...password-protect!  thanks
Post Reply
about | contact