Password Protect Files

[E.Q.]

I have a database developed and used the database splitter wizard to create
front and back ends. I edited a copy of the front end to create a file with
limited functionality that I would like my employees to use. The original
front end will be for me and my fellow supervisors to maintain the database.
I password protected both front end files but when I tried to password
protect the back end the command buttons that open other forms from the
switchboard do not work. I get an error message that says "Not A Valid
Password."
I can take the password off the back end and rely on the fact that most of
my users are not very computer literate and I believe they wouldn't want to
get in to do mischief. (I'm more worried about one of my fellow supervisors
causing problems when trying to help. His well-intentioned efforts have cost
me a lot more problems than the employees.)
I don't really understand the Access user group security feature. So I was
hoping that someone can tell me what I need to do in the code for the command
button to open a form that is linked to a table in a password protected back
end.
Can this be done or do I need to try to figure out the user group stuff.
Peace.
EQC

 

[John Spencer]

You need to modify the connection string to the linked table to include the
password. For instance, here is the connection string to one of my databases
that has simple password "protection" on it.

MS Access;PWD=passwordHere;DATABASE=C:\Services Division\Service Accounting_be.mdb


John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

 

[E.Q.]

John, your solution looks like exactly what I need, but I'm afraid that my
reliance on the spitter wizard gets in the way of my being able to follow
exactly. I'm assuming the wizard created a connection string for me. I don't
know where to find it.
Would it be the Record Source on the properties list for an individual form
or is there some connection string property associated with the linked table
in the database itself.
Thanks
EQC

 

[John Spencer]

How much VBA do you know? Are you comfortable with creating VBA code.

Linked tables have a connection property. I might have some code around
that will let you set the connection string with the password. Let me
look around.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[E.Q.]

I'm self-taught in VBA and have done some reasonably involved coding in
Excel. I'm not quite as familiar with the Access model, but I have done some
simple coding there.
Years ago I earned a degree in Math and took a few computer courses along
the way. (So I once knew Fortran, Pacal, SAS, and how to code functions in
Maple.)
So in short, I probably know just enough VBA to get myself in trouble.

 

[Joan Wild]

Just open the frontend and delete the table links. Then use File, Get External Data, Link tables and locate the backend. You'll be prompted for the backend password, which will then be stored with the table links.

 

[John Spencer]

Now why didn't I think of that. That's me, always looking for the hard way.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Joan Wild]

You're always looking for a challenge, John. <g>

--
Joan Wild
Microsoft Access MVP
: Now why didn't I think of that. That's me, always looking for the hard way.
:
: '====================================================
: John Spencer
: Access MVP 2002-2005, 2007-2008
: Center for Health Program Development and Management
: University of Maryland Baltimore County
: '====================================================
:
: