problem with append query in access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Windows 200 operating system. Try to open an append query. It indoicates 0
rows added. I've checked all fields and the table has an autonumber field
that I don't include in thew query fields. Help!
 
Dick

I'd say the first problem is that your operating system is no longer
supported by Microsoft -- the Windows "200" OS was superceded about 1800
years ago (just a joke!).

If I had an append query that wasn't producing, I'd approach it this way:
Convert it (or a copy of it) "back" to a Select query
Run the Select query -- does it work?
Convert the working Select query back to an Append query -- does it work?
If not, I'd throw out the query and create a new one to do the same
Click to expand...
thing -- queries can sometimes (rarely) become subtlely corrupt. I usually
don't care how, I just build a new one.

On a purely consistency note, I believe action queries (e.g., Append
queries) aren't "opened", but run.
 
Thanks for the response. I will try your suggestion. Re your comment, I have
always used this format for all type of queries.
DoCmd.OpenQuery "_CreateAgendaforRenewal"
 
Back
Top