A
Adam
Hi All,
I have a database which has a few tables linked to an SQL server.
I have setup a system dsn called 'CSC Data Repository'.
When the database is opened i have a form open which links to a query.
So as it is looking at the odbc linked tables it prompts me for the
password each time.
Is there a way I can save the odbc password in the database so it
doesn't prompt me?
Many Thanks!
Adam
I have a database which has a few tables linked to an SQL server.
I have setup a system dsn called 'CSC Data Repository'.
When the database is opened i have a form open which links to a query.
So as it is looking at the odbc linked tables it prompts me for the
password each time.
Is there a way I can save the odbc password in the database so it
doesn't prompt me?
Many Thanks!
Adam