I have heard that SQL can handle more requests at one time etc then DSN.

How many connections can a DSN handle at one time? Also is it Access that can't handle all the connections or is it the DSN?

Because what if I used a Provider string of a direct location to the database, then would the connection issue be non-existent?

Thanks for any information!