Try to put (local) instead of LOCAL (and don't forget parentheses.
>Hello Eric, thanks for the reply. I think OPENROWSET is what I am looking for, but I can't seem to get it to work. I keep getting an error. Below is my select statement and the error I am getting. Can you tell what I am missing? Thanks for the help.
>
>SELECT Inventory.Descr, Inventory.InvtID, Inventory.User6
>FROM Inventory
> INNER JOIN OPENROWSET('SQLOLEDB',
> 'server=LOCAL;User id=x;password=123;
> database=MEDex',
> inventory) AS LocalInv
> ON Inventory.InvtID = LocalInv.solomonid
>
>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'emnsql02'. Reason:
>Not associated with a trusted SQL Server connection.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com