Re: Access 2003 - ODBC File Data Source - Relink every Access Sess
From: Mike L (MikeL_at_discussions.microsoft.com)
Date: 02/10/05
- Next message: Johan Henningsson: "Communication link failure"
- Previous message: Frank Hickman [MVP]: "Re: Access 2003 - ODBC File Data Source - Relink every Access Sess"
- In reply to: Frank Hickman [MVP]: "Re: Access 2003 - ODBC File Data Source - Relink every Access Sess"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 10 Feb 2005 12:15:03 -0800
IT WORKED!!! Frank you rock! Thank you.
"Frank Hickman [MVP]" wrote:
> "Mike L" <MikeL@discussions.microsoft.com> wrote in message
> news:2224CEB1-4718-4126-8A62-FA0FB2D1A706@microsoft.com...
> > Thats the problem, there is no check box setting to save password.
> >
> > Two parts to look at; "Creating the ODBC connection" and "Access
> > connecting
> > to SQL Server".
> >
> > Creating the ODBC connection
> > Start-Control Panel-Administrative Tools-Data Sources(ODBC)
> > ODBC Data Source Adminstrator dialog box pops up.
> > Click on System DSN, click Add, select SQL Server, click Finish.
> > Box pops up, titled "Create a New Data Source to SQL Server."
> > Enter in Name, Description and select Server, click Next.
> > Select "With SQL Server authentication using a Login ID and password
> > entered
> > by the user."
> > By default the "Connect to SQL Server to obtain default settings..." is
> > checked.
> > Enter in Login ID: sa
> > Enter in Password: (I enter in password)
> > Click Next, "Change the default database to:" I select the database.
> > "Attach database file:", I don't touch this.
> > There are other options on this step but none that have anything to do
> > with
> > saving a password. I click next.
> > "Change the language of SQL....", defaults to English, I don't touch.
> > "Use strong encryption for data", I don't touch
> > "Perform translation for character data", default checked, I don't touch.
> > "Use regional settings...", I don't touch.
> > "Save long running queries to the log file:", defaults to local drive, I
> > don't touch.
> > "Log ODBC dirver...", defaults to local drive, I don't touch.
> > Click finish. Click on "Test Data Source...", comes back "Tests Completed
> > Successfully!", I click on OK. I'm now back at "ODBC Data Source
> > Administrator".
> >
>
>
> This part is all correct.
>
>
> > Part Two: Access connecting to SQL Server
> >
> > I open Access Project, I double click on a table to open it, dialog box
> > pops
> > up, "SQL Server Login", Login ID: sa, and the Password is blank. I type in
> > the password click OK, and the table appears with the records.
> >
>
> Ah, I see what's going on. Your table is already linked to Access so when
> you double click on it, it requests the password because when it was
> originally linked the Save Password was not checked.
>
> Do this, remove the link to the table then right click in the table view.
> Click on the Link Tables option and select your ODBC data source as usual.
> When prompted, enter the password. When the Link Tables dialog pops up to
> select the table to link to, select the table and then check the Save
> Password checkbox. This is the only place it will be for linked tables.
>
> <snip>
>
> --
> ============
> Frank Hickman
> Microsoft MVP
> NobleSoft, Inc.
> ============
> Replace the _nosp@m_ with @ to reply.
>
>
>
>
- Next message: Johan Henningsson: "Communication link failure"
- Previous message: Frank Hickman [MVP]: "Re: Access 2003 - ODBC File Data Source - Relink every Access Sess"
- In reply to: Frank Hickman [MVP]: "Re: Access 2003 - ODBC File Data Source - Relink every Access Sess"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
