"Unknown" Error 1

[bdpitta]

Perhaps someone more familiar with Access or Crystal Enterprise 8 might be able to help me with this perplexing problem.

I have Microsoft Access 2000 installed on my PC and up until the day I installed Crystal Enterprise 8 it worked perfectly.

About 2 days after I installed Enterprise, I uninstalled it because it wasnt really what I was looking for.

Ever since then, Access does not work correctly.

I can open a database file with Access and get all the way to the main dialog box with the list of tables, querys, forms etc. But if I try to open a table, I get a simple error dialog that says "Unknown". I can create new tables in design mode, but once I try to open them I get the same (ever-so helpful)error message "Unknown". I can even open Forms in design mode and add columns from my tables to the form. I can also create new forms. But once it comes time to access data from the tables, it alway comes back with the same error. The error dialog box says "Microsoft Office" in the title bar and "Unknown" in the body, nothing else.

Naturally I checked these same database files on different PCs and they worked perfectly. Strangely, I can also still write crystal reports which read data from these tables and it workes fine. It is only when trying to open Access tables on my PC that I get this error.

So, of course the first thing I did was make sure I had all of the Office Updates and I did. Next I uninstalled Office completely and then reinstalled it, but still the same problem. Next I did a system restore back to a time when I didnt have that problem and still nothing worked. I even tried reinstalling Crystal Enterprise but this also did not fix the problem.

I am guessing that this problem has something to do with Crystal Enterperise, but I am definately not sure. But I have comepletely run out of ideas. My only hope is that someone has encountered something similar to this before and might be able to help.

Any advice would be greatly appreciated.

Thank you,
Brian

 

[dhookom]

I had problems with a couple users at work that had CrystalReports and Access loaded. Crystal seemed to have "hi-jacked" the DAO library. Try open any module (even a blank one). Select Tools|References and scroll to find the reference to the DAO library. Select it and look at the file name and location of the registered DAO Library. On my work PCs, this pointed to a file in the Crystal Reports subdirectory.

To correct the problem, all I had to do was re-register the Microsoft DAO 3.X or 4.X object library.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[faeryfyrre]

And if that doesn't work try Microsoft's catch-all problem solver - Uninstall/Reinstall Access.

Alec Doughty
Doughty Consulting P/L

"Life's a competition. Play hard, but play fair"

 

[bdpitta]

In case anyone ever has this same problem, I finally got Access running again. I just had to type this prompt into the command line, and like magic, my Access was back. I am not sure what exactly it does, must be some sorceror's spell.

RegSvr32.Exe C:\Windows\System32\msjtes40.dll

 

[dhookom]

Your command did what I suggested by:
[blue]To correct the problem, all I had to do was re-register the Microsoft DAO 3.X or 4.X object library. [/blue]

Duane
MS Access MVP
Find out how to get great answers faq219-2884.