I have a database which is split into front end and back end. The front end 
is password protected but the backend isn't Is it possible to protect both 
with the same password? I've tried protecting the backend with a password 
but when I open the front end it can't "see" the backend.
Any ideas?
Thanks
Tony 

Put a password on the backend, then, after opening the front-end, use the 
Linked Table Manager to update the links (just like you would if you had 
moved the backend). You should be prompted for the 'missing' password during 
this process.

You should only need to do this once, as the password (once supplied) will 
be remembered from session to session.

-- 
HTH,
George


"Tony Williams" <tw@invalid.com> wrote in message 
news:OgrhiZHKIHA.2176@TK2MSFTNGP06.phx.gbl...
>I have a database which is split into front end and back end. The front end 
>is password protected but the backend isn't Is it possible to protect both 
>with the same password? I've tried protecting the backend with a password 
>but when I open the front end it can't "see" the backend.
> Any ideas?
> Thanks
> Tony
> 

Thanks George
Tony
"George Nicholson" <GeorgeNJunk@Junkmsn.com> wrote in message 
news:uVc$buHKIHA.484@TK2MSFTNGP06.phx.gbl...
> Put a password on the backend, then, after opening the front-end, use the 
> Linked Table Manager to update the links (just like you would if you had 
> moved the backend). You should be prompted for the 'missing' password 
> during this process.
>
> You should only need to do this once, as the password (once supplied) will 
> be remembered from session to session.
>
> -- 
> HTH,
> George
>
>
> "Tony Williams" <tw@invalid.com> wrote in message 
> news:OgrhiZHKIHA.2176@TK2MSFTNGP06.phx.gbl...
>>I have a database which is split into front end and back end. The front 
>>end is password protected but the backend isn't Is it possible to protect 
>>both with the same password? I've tried protecting the backend with a 
>>password but when I open the front end it can't "see" the backend.
>> Any ideas?
>> Thanks
>> Tony
>>
>
> 

George tried your solution but when I use the Linked Table Manager to update 
the links I get a message that says Not a valid password but no option to 
input one?
Any suggestions?
Tony
"George Nicholson" <GeorgeNJunk@Junkmsn.com> wrote in message 
news:uVc$buHKIHA.484@TK2MSFTNGP06.phx.gbl...
> Put a password on the backend, then, after opening the front-end, use the 
> Linked Table Manager to update the links (just like you would if you had 
> moved the backend). You should be prompted for the 'missing' password 
> during this process.
>
> You should only need to do this once, as the password (once supplied) will 
> be remembered from session to session.
>
> -- 
> HTH,
> George
>
>
> "Tony Williams" <tw@invalid.com> wrote in message 
> news:OgrhiZHKIHA.2176@TK2MSFTNGP06.phx.gbl...
>>I have a database which is split into front end and back end. The front 
>>end is password protected but the backend isn't Is it possible to protect 
>>both with the same password? I've tried protecting the backend with a 
>>password but when I open the front end it can't "see" the backend.
>> Any ideas?
>> Thanks
>> Tony
>>
>
> 

Tony Williams wrote:
> George tried your solution but when I use the Linked Table Manager to
> update the links I get a message that says Not a valid password but
> no option to input one?
> Any suggestions?

You might have to delete the links and re-create them from scratch.

-- 
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com