Hi Nancy ---

Sounds like you're all over the place with this one :-)

OK, let's try this with remote views, which will be easy to work with in the Grid. From Command Window MODIFY DATA testdata. From the Database menu, choose Connections. From that window, choose new and then select your DSN and enter your userid and password (as required). Test it through the Verify Connection button. Then hit OK...you have a connection. Back at the Database window, go back to the Database menu and choose New Remote View. When the View Wizard or New View dialog comes up, choose View Wizard. At the very first screen thereafter, you are shown DSNs. To see your DSN, click on the Connections radio button. Now choose the new Connection and press the Next button. At this point you should see tables and fields. Select a table, Hit the ">>" to move all fields over (if you want all fields). Now you go through Sort and Filter dialogs. Ignore them from now. When you get to Finish, you'll be prompted for a name. Call it "vuemytable" or whatever you like.

Now, in the DataEnvironment of the form with the grid, Add the new view. You can then use the Grid builder to hook the Grid to the view and...there you have it.



>I a trying to open a MSAccess file (.mdb) to be displayed in a grid via Visual Foxpro. The following is what I have attempted to run but
>VFP is looking for a .dbf instead. Could someone guide me to the correct way? Thanks!!!
>
>My form contains the "MS ADO Datacontrol Version 6.0" control with properties of:
> Data Source Name = MSACESS (previously created via ODBC),
> Command type =TABLE,
> RecordSource = test.mdb (MS ACCESS file)
>
>This is the code In the load event:
>OPEN DATABASE testdata
>CREATE CONNECTION MYCONN DATASOURCE "MSACCESS" USERID "admin"
>SELECT * FROM d:\test.mdb