Using SQL Server Tables

[Guest]

Forgive me...I'm learning, so I hope this makes sense...

I have an application that was linking to Access tables in another Access
DB, but the DB I was linking to has recently been move to SQL Server. I have
managed to identify and link to the SQL Server tables I need and created
queries to feed forms with new field names. It all seems to be working, but
whenever I log in for the first time I have to reestablish the ODBC
connection. What is the best way to make this seemless to the user. Is ODBC
the right way to connect to SQL Server? Should I put VB code in the On Load
of Switchboard to activate an ODBC connection to the SQL Server? Either way,
I'll need a little hand-holding or link to a website that might help.

 

[Brian]

Forgive me...I'm learning, so I hope this makes sense...

I have an application that was linking to Access tables in another Access
DB, but the DB I was linking to has recently been move to SQL Server. I have
managed to identify and link to the SQL Server tables I need and created
queries to feed forms with new field names. It all seems to be working, but
whenever I log in for the first time I have to reestablish the ODBC
connection. What is the best way to make this seemless to the user. Is ODBC
the right way to connect to SQL Server? Should I put VB code in the On Load
of Switchboard to activate an ODBC connection to the SQL Server? Either way,
I'll need a little hand-holding or link to a website that might help.

When you create linked tables, put a tick in the "Save Password" box.

 

[Guest]

Awesome. Thanks....can't believe I missed that...you made my day.