hi people, apologies if i am digging up what had been mentioned and resolved. i surfted the net for my issue which is that my split database is stuck.
i have a back end daatbase on shared folder and a front end on my local drive - it was used to process approx 50000 rrows of record.
things were working fine - i hb built a macro that activates a series of append, transfer links etc and when i run it, it takes under 2mins
then problem arose. when i run the macro, the queries were stuck somemore. the status on the bar reads "run query" but didnt go beyond that even after 10-20mins. since i was unable to run the macro
i have tried all sorts of workarounds like planting the back end on my local drive, countless compacting and repairing, try to delete off non critical stuff from the table and keeping a table on as per a suggestion.
what i noticed is i would run the macro and when it comes to the "run query" message, the progress bar just freeze and i hear a "rumbling" sound (like roar of engine and of course not as loud) from the computer which sounds like the computer was working really hard to process the macro.
i was able to process the data successfully if i limit the data to around 10000 (ive tried 20000 and the database got stuck again).
Anyone else has experienced this ? has it to do with the fact i am linking files whcih sit on shared drive (used by many ppl) and because i am splitting the database - whcih i dont think so as i have tried moving all linked files / back end to local drive and re establishing the links
