>Is there a way to make a odbc or oledb connection to a table or dbc in another computer through the internet via tcp/ip?
Yes - under NT/Win2K/XP, you can specify a share using an IP address for the servername in a UNC; you essentially have a (relatively slow) file server connection referencing the table by UNC; eg:
I have a server whose IP Address is 64.252.xx.yy, with a sharename called 'MyData'. If I want to open the table MyTable.DBF on that system, I can specify the filename as \\64.252.xx.yy\MyData\MyTable.DBF under these operating systems. Win9x does not permit the direct use of an IP address as a machine name in a UNC; you must resolve that name to a NetBIOS name using the LMHOSTS file to map a machine name to an IP address, and use the machine name rather than the IP address in the UNC. Both ODBC and OLEDB support UNC-based file names