Article Q137944 explains how to create a remote connection or view programmatically.

The problem that I have is that I don't see a way to specify a USERID and PASSWORD for a VFP table or ACCESS table and also a way to specify where the SERVER with my data is.

Is this possible only with SQL Server Data Sources? I am trying to do this with an NT Server. Is this possible? Thank you in advance.

This is the code in Article Q137944:
CLOSE ALL
SET DEFAULT TO c:\temp
CREATE DATABASE zdb
CREATE CONNECTION zconn DATASOURCE sqltest USERID sa PASSWORD ""
CREATE SQL VIEW zview REMOTE CONNECTION zconn AS select * from ;
pubs..sales
USE zview
BROWSE