Re: slow process when I save a new record

From: Victor Koch ("Victor)
Date: 02/23/04 

Date: Mon, 23 Feb 2004 18:22:19 -0300

Hi Tsevy, before add a new record open a recordset empty,

Rs.Open "Select * from tbl_1 WHERE 1=2",.......
Rs.Addnew
......
......
Rs.Update 

--
Un saludo, Víctor Koch.
"Tsevy" <anonymous@discussions.microsoft.com> escribió en el mensaje
news:3297E887-4EEE-4112-AFF8-46387322AE2A@microsoft.com...
> 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
>

Relevant Pages