>I'm using VFP5.0a
>
>This is the 1st time I've created a remote view and the 1st time I've used ODBC. I have 2 problems with it.
>
>The connection is to a table in an MDB file.
>
>1. EVERY time I try to use the remote view (drop in a form or just browse it) I have to point at the MDB file (it's on the A: drive). I can't find a way to define the connection or view to automatically find it.
>
>2. After pointing at the MDB file, my CURDIR() has changed to A:
>
>Am I doing something wrong? I can't find anything in the help file.
>
>TIA

I have MS Access driver version 3.51.171300 and I can specify the name of the MDB during creation of the data source in the ODBC datasource administrator. In VFP, I create a connection for this DSN and a remote view to a table. I just do USE mydbc!myremoteview and I can browse the data no questions asked on the MDB. Probably you may want to update your Access ODBC driver. HTH