Of the top of my head, try changing
"User ID=Murray M-R;Date Source=" & strCurrentFileName & ";" &
to
"User ID=Murray M-R;Data Source=" & strCurrentFileName & ";" &
There could be other stuff but I'm glazing over right now!
Peter Jamieson
http://tips.pjmsn.me.uk
On 20/11/2009 20:22, Murray Muspratt-Rouse wrote:
"User ID=Murray M-R;Date Source="& strCurrentFileName& ";"&