slow process when I save a new record

From: Tsevy (anonymous_at_discussions.microsoft.com)
Date: 02/23/04 

Date: Mon, 23 Feb 2004 10:16:05 -0800

Hi
  I designed form with 35 text_boxes

I have a table with 40.000 records and with 35 fields
when I save a new record it took 3 minutes

I decided to split this table (35 fileds) into 7 tables (with only 5 fields each)
I minimize the length on each field ( text max 50)

I created 7 recordsets for each table … mors_1…and / Strsql = Select * from tbl_1
and I saved the new record into 7 tables

   A …. firs I save tbl_1
           tbl_1 primary key is “ auto number “
   B. then I save tbl_2
           tbl_2 primary keys is >> primary keys from tbl_1
   
  C Then I save tbl_3…………………
         tbl_3 primary keys is >> primary keys from tbl_1…….4,5,6,7

is still taking around 5 minutes to save all this tables

What will be the best approach to save faster

Thanks

TA