You need to set a reference to the ActiveX Data Objects Library.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Tony" wrote in message
ups.com...
Hello,
I'm sorry that it took so long to answer...
first, Thanks for the help.
I'm getting a compiling problem when I run the macro that appears in
the link that you gave.
The error occours in the following line:
Dim rs As ADODB.Recordset

notice that I don't have Microsoft Access installed in the computer...