[Smile] Thanks...All your comments are certainly putting me on the correct road for a successful implementation!

[Frown] Damn it! [Frown] As Kent so rightly pointed out...I forgot to say that I am using an "SQL Server"...Sorry!

I think that the database that we need to "connect" to will not use Windows Authentication, so I will need to specify a username and password for the database. Is it possible to script this?

Maybe the idea of automatically creating a User DSN would be useful for many people - Would anyone like to see it native to Kix?

Lee

Shawn...Yeah fine thanks - you? Things are pretty hectic here...We are going live with a database on Monday so I have to create hundreds of UDSN's; which as always I haven't got time for!