strange and weird Access problem

[maxmangion]

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.

 

[SQL_Hell]

Hi,

Have you tried creating a new database and importing all of your objects from the old database?

 

[maxmangion]

yes i've tried your suggestion but to no avail. Also, I am sure that the problem is not particularly related to one database, because on my pc i have about 6 databases, and the same problem occurs on all of them.

Even if i try to create a new db, i can work in design view, but when i try to open a form, table or run a query, the same problem occur.

Any other suggestions are greatly appreciated.

 

[The Stoat]

Hi Max,

In the help menu in the main database window is an option called Detect and Repair. You need to have the CD handy. You don't need a DB open just Access. It should tell you if their are any problems with the installation.

TS

 

[maxmangion]

thank you for the tip, i will give it a try when i get back home.

However, i pretty much doubt it that it will solve my problem, because the fact that i have uninstalled/re-installed Microsoft Office twice, i believe that it should have solved such a problem.

Thanks.

 

[The Stoat]

Max,

Found these links may be of some use??

http://support.microsoft.com/default.aspx?kbid=823227&product=acc2003

http://forums.about.com/ab-databases/messages/?msg=1971.1

TS

 

[maxmangion]

thank you for posting the links. i gave a look at the links, and the one from the Microsoft website doesn't seem to offer a solution to my problem since i have not upgraded to 2003. However, in your other link, someone said that encountered a similar problem and the resolution was that he moved the monitor resolution from 800x600 to 1024x768.

i doubt it that this might be the resolution for my problem, but it is always good to give a try.

Anyway thank you very much for your interest, i'll really appreciate it.