Append Query From ODBC Crashes Instantly ??

[mordja]

Hi,

I have an append query which appends approximately 100000 records from a linked ODBC table to a local table. It ran the first time I used it, but everytime I try an use it now, it causes access to not respond straight away. What is causing this is it an access problem or a problem with the tables Im trying to append from. To do it manually only takes me about two minutes.

Thanks

Mordja

 

[Crowley16]

when you say not respond, do you mean it actually crashes or just shows the working cursor and doesn't respond to commands?

the latter might just mean it's taking a LONG time to do things...

--------------------
Procrastinate Now!

 

[mordja]

Crowley16,

No it doesnt actually crash. But as soon as you click on next the Not Responding message appears next to the Access logo. Ive let it run for a long time without inteference and no result. Ive even cut the actual data set down that would be appended to a few hundred rows and it still crashes(stops responding) instantly.

Any other suggestions ?

Thanks

Mordja