>Hi Everyone:
> I need big help in connecting an Access database from my Fox application through an ODBC. My Fox application needs to work with an Access database and I don't know how to do this. I know how to link Fox database through ODBC, but I have no idea how to connect access database from Fox app.
>
>Thank you for you help
>MA
Works the same way as any other remote data source -- remote views or SPT. You just use the Microsoft Access ODBC Driver. You can create a DSN in the ODBC Administrator then create a connection in the VFP DBC for use in creating remote views.
I have a free ODBC DSN CLASS in the Files section here in the Win32/API category. It is heavily commented and contains example code of how to do this programmatically with VFP code.
Mark McCasland
Midlothian, TX USA