>No difference in performance. The only thing is where in the registry the DSN is located (and from where it is available).
>
>A user DSN is saved into HKCurrentUser and available only when the user in which the DSN is created is logged.
>
>A system DSN is saved into HKLocalMachine and is available to every logged user.
Theoretically, I agree. However, I have had no problem logging in on someone else's computer using my UserID and still having a USER DSN available that was created under another User's ID. FWIW, I always create User DSNs. These were Win9x computers.
Mark McCasland
Midlothian, TX USA