[mso] Passwording Access 2002?

From: "Dian Chapman" <dian@xxxxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Date: Mon, 8 Sep 2003 17:06:34 -0500
I'm developing a custom front-end in Word with VBA/ADO. It's for a medical
client, so the DB needs to be passworded...which I've never done with
Access. I read Help and opened the DB "Open Exclusive" per instructions. Set
the pass. 

I now need to work out the correct connection string. But I've never used a
password to connect to an Access DB, only SQL. The ADO provider (driver) for
Access doesn't even show a password syntax. So I tried the SQL syntax, but
it didn't work. 

Error: Run-time error (long num)
Cannot start your application. The workgroup information file is missing or
opened exclusively by another user.

I'm checking on the Connection string elsewhere...but any Access gurus out
here familiar with what all this Exclusive user stuff means? Yes, that's how
I had to open the DB to set the pass. Seems like the only way? 

Any insight into Access 2002 and how it handles DB passwords to help me
understand this process...would be appreciated.

Dian D. Chapman
Technical Consultant, 
Microsoft MVP & Instructor

Free Tutorials: www.mousetrax.com/techtrax
Free Word Tips & Tricks eBook: www.mousetrax.com/books.html
Learn VBA the easy way, thru video! www.mousetrax.com/techcourses.html

  


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
[mso] Passwording Access 2002?

Other related posts:
