Connecting to MSACESS 2000+ (ie 2003) and sending in a password

Hello,

I have an MSACCESS file with a password on it. I'm trying to connect to it
using Delphi 6's TADOConnection. I'm setting LoginPrompt true to be
prompted for the password. Keep getting "Cannot start your application.
The workgroup information file is missing or opened exclusively by another
user".

I get it whether trying to connect to an MSACCESS97,. MSACCESS2000 or
MSACCESS2002-2003 file. Bascially whenever I try to pass in a password, I
get the above error even if the file has no password on it.

Sample connect string:

adb_downtime_access_db.ConnectionString :=
'Provider=Microsoft.Jet.OLEDB.4.0;Password="";Data Source=' +
tex_file_name.Text + ';Persist Security Info=True' ;

If I fill in password (make it other then "") I get the above error. Or If I
leave off the Pasword="" and enter via login prompt, get the same error.

Thanks in advance.


.