Connecting to an Access (with password) database

[bigscorpio]

I am having a desperate struggle finding the correct connection string to connect my VB 2005 project to an Access 2003 database that is password protected! The connection string I using is string "MainConn = New OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;D ata Source=C:\Globa l\Database\glob al.mdb;Jet OLEDB System Database=C:\Use rs\Peter\AppDat a\Roaming\Micro soft\A ccess\System.md w;Jet OLEDB Database User IDadmin;Jet OLEDB Database Password ******;")"
Any iseas?

[yarbrough40]

I think you have too much stuff in there... try this:

"Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=C:\Globa l\Database\glob al.mdb;Jet OLEDB:Database Password=****** ;"