A strange virus that disables reports?

[jankristensson]

I was working developing a MS-Access 2003 database. Suddenly I noticed that whenever I tried to access an exisiting report nothing happened. So I tried to create a new report using the report wizard. The report wizard told me that it could not create the report. So I exited the application, re-entered Access and tried to create a new database starting form scratch. The same symptom appeared. No reports could be created. I took my original .mdb file to another computer not connected to the first one. There everything worked fine. But on a third computer networked to the first one the problem reappeared. I disconnected the first computer from the network, removed and reloaded MS-Office 2003 but the problem would not go away. I ran the latest AVG virus scanner but it fould nothing. Has anyone had the same problem?

[nico5038]

Looks like the database crashed, try these MS Access database recovery steps:

1) Create a backup of the corrupt database. (Just in case of)

2) Create a new database and use File/Get external data/Import to get all objects of the damaged database.

3) Try these Microsoft solutions:
Repair A97/A2000:
http://support.microsoft.com/support/kb/articles/Q109/9/53.asp
Jetcomp:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q273956
and/or read the article:
ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;306204

4) Bit "heavier":
Access decompile:
http://www.granite.ab.ca/access/decompile.htm

5) Try a recovery tool / Table rescue
Table datarecovery:
www.mvps.org/access/tables/tbl0018.htm
Access recovery:
http://www.officerecovery.com/access/index.htm

6) Ask a company (will cost $$'s ! )
http://www.pksolutions.com/services.htm

check also: http://www.granite.ab.ca/access/corruptmdbs.htm


Nic;o)

[missinglinq]

It being Access 2003, I have to ask if you recently installed the SP3 update on the trouble machines? The problems associated with this have been legion! Micro$oft is working on the bugs, but there are so many that I expect it's going to be a while before a patch is available. If you do have this update on board, I'd uninstall it and see if this makes a difference.

Go luck!

Linq ;0)>