ODBC Password

system · July 17, 2003, 10:35am

Not that I know of. I think you can only do this at initial link.

[Non-text portions of this message have been removed]

system · July 17, 2003, 9:38am

Does anyone have a way of avoid the prompt for the ODBC password when
using ODBC in Access? I know you can use a file DSN and include the
password in the dsn which helps with Crystal Reports and with the
initial creation of a linked table in Access, but after that, when
you try to access the info in the table the password prompt reappears.

I'm working on a test implementation for 5.2 with ODBC SQL 92 and
Access 2002. Any ideas will be greatly appreciated.

Thanks,

Brian Stenglein
Clow Stamping Co.

system · July 17, 2003, 9:44am

When you choose what tables to link in Access there is a checkbox in the
lower left corner that says "Remember Password". Put a check there and that
will do the trick.
Good luck,
Jeremy Leonard
IT Manager
K-T Corporation

-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Thursday, July 17, 2003 8:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC Password

Does anyone have a way of avoid the prompt for the ODBC password when
using ODBC in Access? I know you can use a file DSN and include the
password in the dsn which helps with Crystal Reports and with the
initial creation of a linked table in Access, but after that, when
you try to access the info in the table the password prompt reappears.

I'm working on a test implementation for 5.2 with ODBC SQL 92 and
Access 2002. Any ideas will be greatly appreciated.

Thanks,

Brian Stenglein
Clow Stamping Co.

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · July 17, 2003, 9:44am

When you initially link to the tables, click 'save password'...

[Non-text portions of this message have been removed]

system · July 17, 2003, 10:19am

Hey thanks you guy's (Jeremy & Sarah). Boy do I feel stupid, DOH!

Brian

--- In vantage@yahoogroups.com, "Leonard, Jeremy" <jleonard@k...>
wrote:

> When you choose what tables to link in Access there is a checkbox

in the

> lower left corner that says "Remember Password". Put a check there

and that

> will do the trick.
> Good luck,
> Jeremy Leonard
> IT Manager
> K-T Corporation
>
>
> -----Original Message-----
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Thursday, July 17, 2003 8:38 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] ODBC Password
>
>
> Does anyone have a way of avoid the prompt for the ODBC password

when

> using ODBC in Access? I know you can use a file DSN and include

the

> password in the dsn which helps with Crystal Reports and with the
> initial creation of a linked table in Access, but after that, when
> you try to access the info in the table the password prompt

reappears.

>
> I'm working on a test implementation for 5.2 with ODBC SQL 92 and
> Access 2002. Any ideas will be greatly appreciated.
>
> Thanks,
>
> Brian Stenglein
> Clow Stamping Co.
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You

must have

> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report

Builder and

> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

system · July 17, 2003, 10:26am

Do you know if there is a way to apply this setting to tables that
are already linked, or will I have to remove that link and recreate
it to save the password?

Thanks,

Brian

--- In vantage@yahoogroups.com, "Leonard, Jeremy" <jleonard@k...>
wrote: