The main difference is that System DSN work for anyone using that system whereas DSN-less work for anyone who has access to the database file. In System DSN connection information is stored in System Registry whereas in DSN-less no static storage of connection information.
