Setting Table.SetTableLocation to remote SQL Server

[jfrost10]

Hi guys,

is there any special trick to assigning a table to a remote sql server db?

Here's the code i'm using
Report.Database.Tables(lngIndex).SetTableLocation
"456.125.123.184", strTablename, ""

but all its doing is truncating the ip number to the path of the actual report (which resides on the local machine, not the server).

Any help would be greatly appreciated, and if possible please just icq me at 54706142. or if you're more comfy with it, just post here. I'll be back to check.

Thanks again,

Jack