password issue on back end database


M

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
 
Ad

Advertisements

J

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 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)
 
M

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.
 
Ad

Advertisements

M

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top