i have a PC running Win XP and Office XP and until yesterday everything was working to perfection. However, yesterday when i tried opening one of my databases, it opened ok in Access, and if i try to work in design view it works fine, but when i try to open a table, run a query, or open a form, Access freezes for a couple of seconds and then i get the following message:
"Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.
The information you were working on might be lost. Microsoft Access can try to compact & repair your open database
here i get an option to check, if i would like to repair my open database and restart Microsoft Access."
Then Access will create a backup of the database, and it doesn't close successfully the original one, leaving the .ldb file visible.
This is happening to all of my databases on this PC, while the same databases works fine on all of my other computers.
I have uninstalled/reinstalled Office XP two times ( from 2 different CD's and 2 differnet serial numbers.) but still the problem is persisting.
Any ideas, what i may try to solve this problem, may i can avoid the hassle of formatting my pc for another time ?
Thank in advance.