PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → OLE DB Access Error
OLE DB Access Error
Débuté par Denis Vaughan, 19 aoû. 2008 12:25 - 1 réponse
#1
Posté le 19 août 2008 - 12:25
Hi, I am working on an application that reads and writes data to an MS Access database. In the database I am using two tables. As a basic test, I created a form with two table controls, one connnected to each Access Table.

When a row is selected in either table I update a variable with the row identifier. I created a Query that I call from a button control which then updates the a column in the chosen record with the value "yes". The table is then refreshed.

This works fine for one of the tables, but the other doesn't update. When I run a test on that query using the run option instead of the view option I get an error:

Error initializing the query
OLE DB access error
Error number 170129

Failure Opening file

System Error Details:
Description=Syntax error (missing operator) in query expression 'utf8'Yes"
Source=Microsoft JET Database Engine
Help Context=5003000
SQL State=3075
Error Number= -2147217900
Native Error Number= -524553244

Can anyone assist as to why the query for one table works and the other doesn't ?
#2
Posté le 21 août 2008 - 12:36
Hi,

This is solved. I think it was the name of the table in the external database, it was very long and contained '_' characters. When I changed this it worked.

DV
→ Revenir à WINDEV 2024