Query getting stuck

  • Thread starter Thread starter ChrisBat via AccessMonster.com
  • Start date Start date
C

ChrisBat via AccessMonster.com

Hi

I have an access database (2k) that imports data on an hourly basis from a
Dbase application. When i run each of the import/append queries seperately,
there's no problem - everything bahaves itself. Where the problem arises is
when I use my macro to run the queries - at one particular query, the little
progress bar gets to then end, and then....stops - it just sits there. This
query is a duplicate of 4 others in the same database, all of which work
flawlessly, the only thing that's changed is the Area Code. Please help??
I'm so confused.....
Thanks,
Chris
 
Anybody help with this?? My boss is really breathing down my neck for this....
Thanks!! Chris
 
Chris,

I tend to skip macros and go straight to the code, but I would take a look
at a couple of things.

Can you do a select query of the data you are trying to append? Does this
query work?

Is the order the queries are run in important, can you switch them to see if
it runs if in a different order?

Is the table(s) in your dbase application open, maybe someone is sitting on
a data entry screen and your query won't run unless the record is unlocked?

Is the macro hanging, or has it completed, but it just hasn't refreshed the
screen?

Mark
 
Hi Mark,

Thank you very much for your help......
Can you do a select query of the data you are trying to append? Does this
query work?
Click to expand...

Yes, I've tried that a couple of times to make sure I wasn't going crazy.
Is the order the queries are run in important, can you switch them to see if
it runs if in a different order?
Click to expand...

Semi-important - I will switch up what I can and see if that makes a
difference.

Is the table(s) in your dbase application open, maybe someone is sitting on
a data entry screen and your query won't run unless the record is unlocked?
Click to expand...

The tables are open, but a previous database that my group used had no
problems importing the data.
Is the macro hanging, or has it completed, but it just hasn't refreshed the
screen?
Click to expand...

Good question - how would I find this out? Is it as simple as CTRL-Break and
seeing if the data has been pulled? If this is true, what's the next step?
If this is false, what's the next step??

Thanks again!!
Chris
 
For MChrist (or anyone else that can help)..................
Thanks,
Chris
 
Back
Top