Linked server
Thanks for the reply.
Could you give me some direction how to do that. The linked server is call Kpay and the table I'm after is tblPayRollInfo and the fields are field1, fieild2, address, name.
Thanks
I have created a linked server in SQL 2000 to a database on a Unix server and all the tables show in SQL enterprise manager Linked Servers. The linked server in called Kpay
Is there any way to directly link to the tables on the Kpay linked server directly with Access 2000 so querries can be run...
Could you point me in the direction of what "Please make sure to add the Microsoft Outlook Object Library to your References." means in the artical you linked to.
Thanks again
Is there any way to send the contents of a query by email other than using the SendObject. I am having all sorts of problems with security since upgrading form exchange 5.5 to 2003. I used to be able to send without any problems using Outlook 2000. I thought there might be away to do it...