Bonjour,

I have to open/modify an Access database from within a VFP9 program

I get Connectivity error when trying to open a Access table from VFP9.

The steps for creating a Remote view:
1. From database designer I try to create a New Remote view
2. Click View Wizzard
3. Select MS Access Database from the list of data sources. (Leave ODBC checked)
(Previousely my database was "attached" to MS Access Database )
4. Access database is shown in the wizzard
5. Select table/fileds as needed
6. Click Finish
7. When trying to Save I get the error message
(See image attached)

Since I haven't written anything manually, this syntax error message makes no sense.

Suggestions/sample code are welcome.

Thanks.