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