Wierd slow to open problem

[FISHiEE]

Hi,

I have a database here that is run by users who use either Access 2002 (XP) or Access 2003.

I have noticed something which to me seems odd and dunno if any of you guys could explain why or how to resolve it?

If one of the 2002 users opens the database it opens fine first time (I use 2002 myself for development) however if a 2003 user opens it it can take 30s+ to open, but then if they close it it will re-open in just a couple of seconds like for the 2002 users.

However if a 2002 user opens it once a 2003 user has just closed it they will then take 30s or so to open it, but then again if they close and re-open it's almost instant.

Is that normal?

Incidentally office 2007 doesn't seem to suffer from this, but it's dead slow at running the database anyway so I'm not going down that route for the forseeable future!

Thanks in advance for any input!

I did try the recommended method of searching this forum using google but it didn't seem to work for me

 

[gemma-the-husky]

look at MS knowledge base for "performance issues"

theres a load of suggestions

Having said that I tried all the suggested fixes, without really getting a solution. I had this when using A2003, with a FE/BE split.

I found that having the BE as A97 format produce much better results, so now I do that. BE A97, front end anything

Try that