Thread: [SOLVED] Speed this up at all?
View Single Post
Old 07-17-2017, 06:47 AM   #1
Gasman
Access newbie
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 1,445
Thanks: 178
Thanked 202 Times in 188 Posts
Gasman will become famous soon enough
Speed this up at all?

Hi all,

I obtained a Holiday Planner from the net.
We have been using it as a single user mde, but I have been so used to having split DB that I amended the code forgetting that the tables in my mdb version were empty, and the tables in the mde version had the current holiday entitlements.

I managed to get a good version from backup. Phew!

So I have split the mdb, but it appears very slow. The BE is in the same place as my other BE DBs and they perform OK. Perhaps it is because it is mdb snd not sccdb?, so I upgraded both FE and BE to Access 2007, but no difference?

I've attached both FE & BE and would be grateful if anyone could give me any pointers to speed it up. It does behave very slow compared to my other DBs with much more data. I've looked at the indices and they seemed adequate, but added a few for dates as well.

pw to login is torch1234
Many thanks.
Attached Files
File Type: zip Holiday Planner V2_be.zip (183.9 KB, 21 views)

__________________
Access novice. Sometimes trying to give something back.
Access 2007
Gasman is offline   Reply With Quote