Access-ADP: tablesize and speed

[Filips Benoit]

Dear All,

I would like your oppinion on this

I have build a access-ADP that is running well for 3 years.
As tables grow in size some actions are slow.
In the code i used ADO, some command.executes but no stored procedures (
never done!)

a. tablesize (1/9/2003)
1. ORDER 37.214
2. ORDER_PHASE 353.198
3. ORDER_PROPERTY 162.667
4. PRODUCT 5.978
5. PRODUCT_PHASE 24.297
6. PRODUCT_PROPERTY 64.540
b. All actions using this tables became slow. Copying an order uses
table 1,2 en 3, so it's very slow.
Solutions.

a. Change the code > stored procedures.
Problem1: I don't know it yet. So I 'll have to give it to another
person !!
Problem2: Even this solution 'll have limits on size, I suppose!

b. Copy the DB as an archive and delete old data (orders and products)
in the running DB.
Orderdelting can by coded. Productdeleting will always be manual.

thanks,

Filip