Developer Forum

Some of the queries I have written inside MS-Access are getting deleted
automatically. And while I run the queries through code, I get this error

'Query should have one destination field'

Explanation: I created a query in MS-access. Ran it from the code. Closed
the database. Started it again, and now for that particular query, it is
showing 'SELECT ;' only. Strange. I am in panic mode now

What can be the possible reason?

My first thought is that the database file is corrupt. Unfortunately it's a
type of corruption that Compact and Repair probably won't fix.

Open a new database file. Import everything from the problem database into
it. If something refuses to import, it is corrupt and you will need to
rebuild it from scratch. See if that fixes the problem.

Also if you have Compact on Close enabled, disable it. I've seen it cause
similar problems.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Show us the code used to run it.

--
HTH,
Bob Barrows

If your mdb file is corrupt.You may try Advanced Access Repair at
http://www.yqcomputer.com/
damaged Access MDB files.

Wangdong

1) You are an employee of such a company

2) You should be disclosing that fact more openly.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.yqcomputer.com/
Tony's Microsoft Access Blog - http://www.yqcomputer.com/
For a convenient utility to keep your users FEs and other files
updated see http://www.yqcomputer.com/
Granite Fleet Manager http://www.yqcomputer.com/