Is Failure of JET SQL/Access Possible?

[sathandle]

Access 97

Is is possible for the JET SQL to become corrupt (i.e. too many design time changes?) and thus not run queries properly?

The query was working flawlessly the other day (likely story)...

I have made no changes to the module used by the query, the query itself or the table underlying the query. I have made changes to the forms within the database. Any insight would be appreciated.

 

[RichUK]

Have you compiled and saved all modules, compacted the db. Failing that try importing everything into a blank new db.

 

[pendragons10]

The answer from experience is absolutely, Jet can take exception to the strangest things (Especially anything not originally invented and owned by MS like......SQL!!!)
Sorry - not much help, but very sympathetic!