Gasman
Enthusiastic Amateur
- Local time
- Today, 01:48
- Joined
- Sep 21, 2011
- Messages
- 14,299
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.
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.