Re: Access 2003 - ODBC - Relink every Access Session

From: Frank Hickman (fhickman_NOSP_at_M_noblesoft.com)
Date: 12/09/04 

Date: Thu, 9 Dec 2004 01:29:28 -0500

I don't think that the password is saved in a File Data Source. I have
linked tables to both SQL Server and Oracle that I do not have to re-link
every time but I use a System DSN. 

-- 
============
Frank Hickman
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.
"Mike L" <MikeL@discussions.microsoft.com> wrote in message 
news:9C2A5D4A-2293-498E-9694-ACE621DBB1F8@microsoft.com...
> Why must I have to relink tables everytime I open my Access 2003 project?
>
> I go to "Linked Table Manager" select all tables, have "Always prompt for
> new location" checked, select my ODBC file under "File Data Source", and
> connects everytime, the problem is I have to do this everytime I open my
> Project in Access 2003 that connects to my SQL 2000 database.