Database taking long time

[danny123]

Hi there,

I have on MS Access database.which was working fine untill now but suddenly it started this strange behaviour.
When i open it it opens without any error but stays in the frozen state for like 5 mins means i cant do any thing or i cant click anywhere.

and after 5 mins it starts working fine.Does anyone have any clue abt this strange behaviour.

Thanks
Danny

 

[Mile-O]

Have you tried compacting it to begin with?

 

[danny123]

Thanks for response.

Yes i did try to compact and repair but no effect at all.

 

[Rabbie]

Do you have any linked tables. It may be taking a long time to get a response from a remote server.

 

[danny123]

Nop , no linked tables in the database.

 

[DJNickWatt]

Do you have any code running when the database opens?