Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Open/Modify Access database - Connectivity error
Message
 
 
To
23/03/2011 08:38: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:
01504639
Views:
39
>Not a field BUT your reply rings a bell...Spasiva.
>
>All table names in my Acces database start with a _ and have spaces in the name.
>
>Example: _help pages
>
>In the error message I get, it refers to _help_pages.ID (It replaces the space from Access with _ (It would have been civilized to tell me that...)
>
>The message says : Syntax eror in query expression '_Help_Pages.ID'
>
>I suppose VFP doesn't accept spaces in names...(BTW this is good)
>
>So, at this point...there's no way out...because I can't change the table names in the Access database.
>
>Or is there ?
>
>-gl

VFP does not allow space in the names, I don't think putting them in double quotes will help, but worth a quick try.
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