Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Open/Modify Access database - Connectivity error
Message
 
 
To
23/03/2011 06:55:25
George Lechintan
Independent consultant
Sebes, Romania
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01504627
Message ID:
01504632
Views:
35
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform