ODBC Save Password Errors!!! (new to access)

[dbrown]

Ok, I recently setup an ODBC data source. I have an access front end (.mdb)
and I've linked the tables with no problem. I see the suggestions on here
across the board have been to select the save passwords option when you link
your tables to avoid multiple password prompts, so in heeding advice, I've
done so; however, I'm still prompted for a password multiple times when
accessing any linked tables.

For instance, I have cascading combo boxes that use the linked tables as row
sources. Everytime I click a new combo box I get a password prompt. I also
have a link on the form to another form with a different linked table as the
record source. When I click on this link, once again, I'm prompted for a
username and password agan.

It seems like it's trying to use windows authentication because everytime it
prompts me for a password I have to uncheck the trusted connection and input
the SQL Server login.

I've looked at my System DSN configuration MULTIPLE times and it says use
server authentication. Am I missing somethig???????

 

[aaron.kempf]

if MDB is 'too complex' then you should jump into Access DAta Projects

ADP has a single connection to SQL Server; it's about 100 times easier
to use against SQL Server data

I find it funny when people use MDB against SQL Server-- it's such a
friggin PITA; i mean-- how much code does it take to use a sproc with
arguments again?


ADP is just plug and play

and all data should live in SQL Server

so congratulations; I'm excited for you.

FILE, NEW, PROJECT (Existing Data)

hope that helps

 

[Aaron Kempf]

Access Data Projects are a LOT easier for SQL Server data

and since 'all data should live in SQL Server' you need to move to ADP

 

[dbrown via AccessMonster.com]

Yep! thx to you both. that's what i've done.

Access Data Projects are a LOT easier for SQL Server data

and since 'all data should live in SQL Server' you need to move to ADP

Ok, I recently setup an ODBC data source. I have an access front end (.mdb)
and I've linked the tables with no problem. I see the suggestions on here

[quoted text clipped - 15 lines]

I've looked at my System DSN configuration MULTIPLE times and it says use
server authentication. Am I missing somethig???????