Why not jut use ADODB? That way you don't need to create any local DSNs
on each computer nor do you need to maintain them. I believe every
Windows install has the Access driver already there so you will greatly
simplify your maintenance and roll out.

Check out msdn.com for more info or just do a google and you'll get
tons of samples.

hth
Mike



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/