Thanks Pete

I can now see the tables but can't query them! I've tried

SELECT *
FROM OPENQUERY(mylinkedserver, 'SELECT * FROM mydatabase.mytable.myfield')

but it aint working. I get this error:
Code:
Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB provider 'MSDASQL'. 
[OLE/DB provider returned message: [Esker][liv-electra:TUNODBC200.ifx][electra] Syntax error or access violation]
OLE DB error trace [OLE/DB Provider 'MSDASQL' ICommandPrepare::Prepare returned 0x80040e14].
I think possibly the problem may be that I don't know what the database name is! I see the linked server name and the tables and views so I've used the same name for the linked server and the database. This is probably wrong!