Crystal Enterprise Causing Problems with MS Access?

[bdpitta]

Perhaps someone more familiar with Crystal Enterprise 8 or Access 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

 

[Turkbear]

Hi,
AFAIK, there is no interaction between CE8 and Access so I cannot see how just a simple uninstall could have affected any of your Access stuff..Have you tried the repair database option in Access? If you have copied the mdb to other PCs and they are accessable, tnen check to see if any permissions have been changed on your PC.
You might want to post this to the MS Access group as well.