I have a LAN with a server and clients attached to it. I created a software which links to a MS ACCESS database through a System DSN named MyDSN on the server. Now I want to connect to this database from the client machines using the same dsn name MyDSN so that the database on the server remains shared to all the other clients. Please send me the code. I am using VB 6, MS Access, System DSN, LAN.