Slow with MS Access

What OS, which version of Access, and how much RAM do you have?

Aren't you the guy that posted to a thread about someone wanting to buy a i1000 saying it was good for what you do. Now you post about it being slow. Simple fact is with the shared video memory and other restrictions caused by it being a low end system you get what you paid for. Add more memory and turn off the XP eye candy, I.E. set it to classic mode throughout, and see if it gets better. 

Message Edited by Ed C on 11-26-2004 07:03 AM

Running XP home editions, sp2, 256K ram, Acess 2003

Add more RAM. 512Mb should be the minimum these days.

This system is indeed a poor candidate for anything but simple office applications - word processing, very small spreadsheets, etc. At its maximum of 512M RAM, you're losing a chunk of that to video memory - and with the SiS chipset, which is not known for performance, you're never going to see good performance with Access, particularly if the database is even moderately large and/or contains a lot of queries or other SQL (or VisualBasic for Apps) code.

If you're within your return period, I'd return the system and order at least an 1150 - if not a 5160 system.

OK, I know the I1000 is a basic unit.  But the slowness does not occur all the time.  When I use Access, I have nothing else open.  Yes, there is a visible difference in the video display.  Otherwise, it works fine.  I will look into getting more RAM

The slowness with Access reminds me of using Lotus 1-2-3 in the days of the IBM PC - 128k of RAM 20 MB hard drive - DOS v3, etc.  If you had a large spreadsheet, you had to turn the automatic recalculation option off because it would recalculate the entire spreadsheet every time Enter was pressed.  Unless someone has an idea, I'll have to take this to the MS Office forum.