Why is Update after ADDNEW sloooooow?

[sacanale]

I have a strange problem that I just can't figure out. I need help desperately.

I have an app that uses DAO/Jet3.5 and VB6 to manage an Access database. I use a data control and form to bind approx. 150 fields. The app works great except for this one issue:

When I add the first new record (using data.recordset.addnew method) it takes about 20 seconds to save the data (on a PIII-700MHZ system). All new adds after that save in less than 1 second. Also, any edits to existing records, before or after the first addnew also save in less than 1 second.

Anyone know why????

[paulw]

Sounds like you are not making the actual connection to the database until you try an add a record. Try forcing a connection in the Form loading event chain.

Paul.

[sacanale]

Thanks for responding Paul.

I believe I have a connection because my app displays the last record in the DB when the form loads. I can edit and move between all records with no delays.

I select "add new record" from my menu and get my blank controls for data entry. Validation works fine, but when the data controls gets the OK to actually save to the DB, the delay occurs - but only on the first new record - all subsequent saves are fine.

I am fairly new at this, so its very possible I have something messed up in the connection, but it appears OK. Any ideas???

[paulw]

Sorry for the delay, been away.

Are you on a network?

Paul

[sacanale]

Yes, we are on an NT Network.

I have tested this locally and over the network. There is very little time difference in performance between the two.
Both exibit the same problem.

I tried playing with Jet settings to increase performance (ie cache, sync mode, buffers) but none have improved the situation.