Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Open/Modify Access database - Connectivity error
Message
From
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:
01504638
Views:
37
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform