I have been using VFP successfully for years, but am now trying to learn about using ODBC/CONNECTIONS so that I can create more efficient client server systems. I know this is elementary for most of you, but it is my first exposure to it so please understand.

I have my database (MASTER) set up on the server.
I create a new database on my workstation (CONNECT1). This database has a connection (also called CONNECT1). I set it up using a connection string:

Driver={Microsoft FoxPro VFP Driver (*.dbf)};UID=;PWD=;SourceDB=n:\appl1\master.DBC;SourceType=DBC;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;

Now when I set up this connection, I specified the database name (MASTER) and also the path (N:\APPL1). In my way of thinking, when I open the database CONNECT1, that should give me access to that connection and therefore access to the tables in database MASTER. But that doesn't seem to be happening. I'm missing something but I don't know what.

Can someone walk me through this process so that I can set up my remote views?

Thanks!

Fred