ODBC Connection?

[Mayo123]

My backend database is located in SQL server, from which I have a few Access databases table( front-end) linked to it via ODBC. Is it a safe that I share the same DSN when I make a connection via ODBC for each front end database? Or should I make different DSN to get connected. Your opinion would be highly appreciated!
Thanks

 

[dhookom]

Don't confuse a DSN with a connection. A DSN is the instructions on how to make a connection. There should be no issue with using the same instructions for creating connections unless you want the connection attributes to vary.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]