[mso] Re: Passwording Access 2002? :VSMail mx2
- From: "Dian Chapman" <dian@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 8 Sep 2003 18:19:44 -0500
HA! I got it!<hee, hee>
First your comments...there ARE a lot of terrific Access MVPs out there...I
know, they're friends and have helped me a lot in the past. DO tell them the
issues. We do use the info you guys pass us about our apps and then we pass
it along to MS and rant when we go to the summit! <wink>
The DB is on our server...but I got it working!<dancing in the aisles>
Granted, my code is a mess from all the testing this and that and my init
string isn't picking up the connection flag properly so the LIVE CONNECTION
isn't set right when the app opens...but I got it working.
FYI...here's the Access ADO Provider string syntax:
========
Dim objConn As New ADODB.Connection
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"data source=" & gstr_DataPath & ";" & _
"Jet OLEDB:Database Password=" & STR_DBPassword & ";"
========
I initially tried just saying Password=(pass constant), but then found a
.NET reference to:
"Jet OLEDB:Database Password='password';"
Once I added the additional obj property syntax, the main error went away
and it was just a matter of getting the quote syntax right (geez I hate
dealing with SQL quote routines!<grrrrr>
Cool! BTW...if you ever decide to move to ADO, yell if you need help. Like I
said, I only experimented with DAO, so I can't compare. But I haven't really
found any limitations with it.
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
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of James LaBorde
Sent: Monday, September 08, 2003 5:57 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Passwording Access 2002? :VSMail mx2
Dian,
No problem. If I ever get the ear of an Access MVP to support the users
like you do, I know I would bend it about the inadequate help. It is
extremely frustrating to try to go to a topic and its not there. Hopefully
they did something about it in 2003.
As for your error, where do you have the mdb? and where do you have your
security settings?
James
-----Original Message-----
From: Dian Chapman [mailto:dian@xxxxxxxxxxxxx]
Sent: Monday, September 08, 2003 3:49 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Passwording Access 2002? :VSMail mx2
>Any reason you are using ADO over DAO?
Yes...it's newer, but also, I never got on the DAO train...or not for long,
anyway. But I've been using ADO for a couple years now and know it pretty
well. Use it for Word <--> DB connect, both Access/SQL and all my ASP/DB
work is in ADO. I had one client ask me to do an Access 97 connection for
him and I ran screaming from that project!<g> I won't take on anything that
isn't 2000+ and using ADO.
>Microsoft really dropped the ball with ADO and there are a number of
>Access
developers who will not use it.
That's surprising to hear, cos' I thought it was pretty well received? I
know VB devs prefer it much more than DAO???
>I don't know how secure you want the application to be, but you can
>also
call an API to verify the user signed onto the computer and base code on
that as well.
Yeah...I may have to check out that route to do an enhancement on it later.
All this HIPAA reg stuff for medical records! But for now I just wanna be
able to get the base connection working with a locked DB and then I'll see
about going up a level. I just wanna understand how Access does this.
>I know you are an MVP and hopefully you won't take this as Microsoft
bashing.
HA! No problem...WE do it all the time!<eg> You should think of MVPs MORE as
"user advocates with a voice" versus "Microsoft advocates." Believe me...you
should hear us in summit meetings! (Especially Greg.<smirk>) We've cause
more than one softie to leave the room in tears/upset. Any softie who walks
into an MVP meeting carrying the company line is very quickly torn to
shreds. True...MVPs do what they do cos' they love the products they use,
but that doesn't stop us from working with MS to make them even better. Most
softies know this and respect us enough to not try to BS us or pull out the
marketing crap to try to appease us. Those who do are later sorry for
underestimating the qualify of MVP expertise! ;-) (Just ask any softie who
has ever tried to blow smoke up Greg's butt!<roflmao> Greg walks into a
meeting and softies try to slip out the back door!<lol> And he's only one of
many hundreds who don't let them get away with anything.)
>If you don't find help here, I have always found one of your fellow
>MVPs
site's very helpful.
Thanks. I've put the word out in a few areas. But I DO appreciate your reply
and insight/feelings about this. I have found some connection strings that
SHOULD work...but I'm still getting this same error. So I'm obviously
missing something related to Access security???? Although much of what I'm
finding is ADO.NET, which I'm not using.<sigh> Oh well...I'll keep digging!
Appreciate the reply!
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
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of James LaBorde
Sent: Monday, September 08, 2003 5:21 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Passwording Access 2002? :VSMail mx2
Dian,
Any reason you are using ADO over DAO? Other than the fact that it is the
newer model? Microsoft really dropped the ball with ADO and there are a
number of Access developers who will not use it. It still can't do a lot of
the stuff DAO can. I've only used connection strings to SQL but found that
what I wanted to do had to be done using DAO. I can't guarantee this in
your case, but have found that this is often the case. I don't know how
secure you want the application to be, but you can also call an API to
verify the user signed onto the computer and base code on that as well.
Unfortunately, Microsoft has also let the Help in Access go downhill. The
last version of Access with a complete set of Help was Access 97. If you
are going to use it much, you may want to locate those help files to aid you
as well.
I know you are an MVP and hopefully you won't take this as Microsoft
bashing. I am simply trying to help convey the feelings of myself and many
other Access developers. If you don't find help here, I have always found
one of your fellow MVPs site's very helpful.
Dev Ashish's site:
http://www.mvps.org/access
James
-----Original Message-----
From: Dian Chapman [mailto:dian@xxxxxxxxxxxxx]
Sent: Monday, September 08, 2003 3:07 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Passwording Access 2002? :VSMail mx2
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
*************************************************************
*************************************************************
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
*************************************************************
*************************************************************
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
*************************************************************
*************************************************************
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
*************************************************************
*************************************************************
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
*************************************************************
Other related posts:
