Form crashes on query syntax

[JeroenMioch]

Guys i really need some help.



I upgraded a syntax in my db and now i get an error message saying the query expression is mission an operator. There were some syntax issues but i corrected them. Still the wrong syntaxis turn up as error message nomatter what i try.

The second weird thing is that it crashes upon opening the form, while the syntax it refers to in the error message is an afterupdate event of one of the fields.

Even if i disable the piece of code with an appostrophe (') the query expression still returns an error.
I tried everything, including rebooting the computer and running the application on another work-station but to no avail.

I could post the synatixis here but the problem is not the code itself, it looks like the application is bugged.

Has anyone seen problems like this before, and know how to force Access to "reset" or something ?

Thanks in advance for thinking with me.

[JoeM]

I would recommend doing the following:

1. Running a "Compact & Repair" on your database. See if that fixes your problem.
2. If not, create a new database, and import all your objects from your old database into the new one. See if that fixes your problem.

These first two recommendations deal with the possibility that your database is corrupt. If neither of these fixes, then it might be more likely that the problem actually is with your code, and not corruption. Which leads us to step 3:

3. Post your code here.

[Missinglinq]

...Still the wrong syntaxis turn up as error message nomatter what i try.

...I could post the synatixis here but the problem is not the code itself...

Being in forced retirement, I troll through and contribute to four or five forums, 8-10 hours a day, and one of the biggest mistakes that I see posters make, on a regular basis, is deciding what 'could' or 'couldn't' be the problem! If you're getting an error message that suggests that you're having a problem with a query, common sense dictates that post the SQL for the Query, at least as a starting point.

Follow Joe's first two pieces of advice and then post your code.

Linq ;0)>

[John_G]

Hi -

Do you compile you code every time you make changes to it? If not, you should, because some of the problems you are having may be due to an error in your code.

The other possibility is that the error is not in your code, but is in a query that the code references.

Do a compile first, and see if that catches an error.

John