Converted DB Runs Slower (97 > XP)

[sopomeres]

I converted and Access 97 database to Access XP and it processes queries and macros a lot slower now. It also increased in size since I converted it. Any idea on why?

Thanks.
Chuck

 

[lupins46]

Did you change your hardware at the same time?

 

[sopomeres]

No...Same hardware.

 

[bocker]

Check this out!

Thread702-206410

 

[lupins46]

Then what you seeing is pretty normal.
The size change is due to a major change in the file structure between A97 and A2000. The maximum database size increased from 1 gb to 2 gb at the same time.
Performance changes are mainly due to additional features.
There are some tips here:

http://www.granite.ab.ca/access/performancefaq.htm

which might help you recover some of the speed.

But in general, every new version of every program runs slower than the previous version as support for new standards gets added.

 

[sopomeres]

Awesome...I will check out it. Thank you!