very slow condense times with Access 2003 on XP

[crazycoot]

I'm support person, not an access developer, so please be gentle. We are starting to roll out XP and Office 2003 to our users and one of the early adopters has found a strange problem. She has an Access db created in Access 2000. It normally only takes about a minute to run a condense and repair on this database. But only if the condense is run from Access 2000 on Windows 2000, or Access 2003 on Windows 2000. Running Access 2003 on XP it takes over 20 minutes to run. This is a concern because she has other databases that can take up to 30 minutes to condense on a Win2k system. It appears that this condense is going to take hours running on XP.

I've googled MS and Usenet and don't seem to find any other references to this problem. Does anyone have any idea what might be happening here?

TIA
Kevin

 

[markphsd]

Can you upgrade the databases to the 2003 format? It might be taking longer because 2003 is doing the compact and repair. I don't think this has anything to do with the Operating system.

That's my educated guess.

Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.

 

[crazycoot]

I thought the database format was the same from 2000 to 2003. They don't get a message to convert when they open it. What's the conversion process?

I'm guessing that once it's converted, Access 2000 users won't be able to open the database. Is that correct?

Thanks for the tip.

Kevin

 

[KenReay]

Hi

At least one of my clients is running Access2000 format mdb, in Access2003, under WindowsXP professional

Have not encountered the problem you are having

Their mdb file is about 60mb when compacted.

The time for their compact relative to yours is probably meaningless, since it depends on hardware spec, but it is a quite acceptable at approximately 3 minutes

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK