password issue on back end database

[magmike]

When I split my database, I noticed that the backend no longer was
protected by the database password. So I set one. I expected this, but
now the front end cannot connect with it. When it opens (after using
the password for the frontend - which is the same as I set for the
backend) it says invalid password.

How can I protect the backend with a password, and allow the frontend
access to it?

Thanks in advance,
magmike

 

[John Spencer]

Simplest way is to include the password in the connection string.

The simple way to do that would be to delete all the links and then link
to the backend again and when prompted for the password enter it. I
believe that you will then be given the option to save the password in
the link.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[a a r o n . k e m p f]

keep your data in SQL Server, and you wont' have to deal with this (it
integrates with Active Directory)

 

[magmike]

keep your data in SQL Server, and you wont' have to deal with this (it
integrates with Active Directory)





- Show quoted text -

SQL: I would love to, but the office wont spring for it.

 

[magmike]

Simplest way is to include the password in the connection string.

The simple way to do that would be to delete all the links and then link
to the backend again and when prompted for the password enter it.  I
believe that you will then be given the option to save the password in
the link.

'====================================================
  John Spencer
  Access MVP 2002-2005, 2007-2008
  The Hilltop Institute
  University of Maryland Baltimore County
'====================================================






- Show quoted text -

Worked like a charm. Thanks!