Michael,

Thanks, it looks like that might help us. I am still getting:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

when I try to run a query such as:

SELECT * from OpenQuery(STL_KF, 'SELECT * FROM hd WHERE file_num = ''FORKEARS''')

so I guess I need to work on the security aspect some more.

As it turns out, I may not need to access a different database. I haven't completely figured out how the guy before me accessed the data, though it looks like a very complex object-oriented framework utilizing ADO.

If you have any ideas about the above error I am getting and how to resolve the security issues, I would be very appreciative. Thnaks for your help so far!

Thanks,
JoeK