>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.
Do you have a field starting with _ in Access ?
If it's not broken, fix it until it is.
My Blog