MS Access 2002 Conversion Issue (Slow Updates) 1

[llafretaw]

Hi,

I have converted an MS Access Db from 97 to 2002, and everything seems fine except for one type of operation.

Basically I have a form that contains a subform (the subform’s recordsource is a temporary table within Access).

The main form contains several buttons that alter the data that is displayed in its subform (continuous form, datasheet view).

I have noticed that the whole process of updating records in temporary table is a lot slower in the 2002 version that the 97 version.

Some of the operations are simply multiplying the value in one field by another field to setting the value in a field to be zero.

I have created recordsets to perform these operations using both AD0 & DAO but it doesn't seem to make a difference.

Does anyone have any ideas as to why this performance hit has occurred?

Thanks.

 

[longhair]

llafretaw,
are the 2 mdb's on the same box? (or was 97 on the same box as 2002?) are / were the 2 mdb's similar in size?
check out the following:

http://www.tech-archive.net/Archive/Access/microsoft.public.access.conversion/2004-07/0219.html

http://www.techtalkforum.com/archive/index.php/t-4813.html

data types? did they change are they optimized?
did you go through your code? looks like dao needs to be added to .recordset
hth
regards,
longhair

 

[llafretaw]

Hi Longhair

Turns out that the 2002 version had increased substantially in size over the day, as opposed to the 97 version, hence the performance hit….dooh one of those obvious ones...cheers for your help and for the links, its appreciated.

thanks,

llafretaw