Jupie23's latest activity
-
JJupie23 replied to the thread Query slow on split database on network.Thank you - where does this code go?
-
JI put my money on the index?
-
JJupie23 reacted to Pat Hartman's post in the thread Query slow on split database on network with
Like.
There is lots here written on the topic. Here is the simplest version of a batch file that does what you need. md c:\DwgLog del... -
JJupie23 replied to the thread Query slow on split database on network.Update: I did a compact and repair on front and back ends. I changed the query as suggested to Pend1Date<date()-14 and indexed the...
-
JJupie23 replied to the thread Query slow on split database on network.Interesting - I had no idea of this method - I am not in a tech role, more of a "citizen developer" type. I will look into this option...
-
JJupie23 replied to the thread Query slow on split database on network.The users have been instructed to save it to their desktops and always open it from there. Clarification - this has always been the...
-
JJupie23 replied to the thread Query slow on split database on network.Thank you for the ideas, I will try them out as soon as I can - but just to fill in info - the main table was just cleared out at the...
-
JI haven't used Access much in several years now, so I am rusty on how to use it and also never knew the full ins and outs, so I may need...