office 2003...

[robbro]

Anyone have any idea what is happening to my office 2003... Everytime i make a new database make a table then try open that table it goes UNKNOWN?

I tried so far doing :

Uninstalled 4-5 times
Reinstalled same about
Deleted registry.
Downloaded some remove hidden data tool Run that.
cleaned temp files.


wot else could i do ? im clueless... it was working fine untill i tried open my work i saved at uni on my home pc... only then it started to mess up everytime.

[icecube]

Is it possible that you are using two differnet versions of Office? One at school and the other at home?

What ever you create at home with 2003 would have to be saved to the right data base extension for the version at school you would be using. Otherwise it would choke on it. You could however go the other way with no problem.. Office 2003 will even allow you to save an Excel worksheet as a Lotus123 file.

If thats not the case, what type data base extensions are you using (saving them as)?

There is one other thing that can mess up thing, and that would be a macro virus. I hope your virus signature files are up to date.

[robbro]

nope its not that.. i try just making a new database at home it still messes up... its like the whole access is corrupted since i opened the file from uni...

[icecube]

Search for a file called normal.dot and delete it.

This is the Office templet file, if its corrupted or infected, it can mess things up.

The file recreates itself the next time you open up office, it would however set your settings to the factory defaults

[robbro]

normal.dot ? couldnt find it

[icecube]

If you are using Windows XP, normal.dot is a hidden system file and may not show when you search for it. If you can't find it, go into My Computer and click on the Tools menu and choose Folder Options. In there, click on the View Tab and put a check where it says "Show hidden files and folders" and UNCHECK "Hide extensions for known file types" and "Hide protected operating system files". Now, when you search for it, you should find it. If you still can't find it, look for it here:
C:\Documents and Settings\<your user name>\Application Data\Microsoft\Templates

[robbro]

darn it... still no luck. Maybe i got a macro virus ? because ive done everything i can think of I virused scanned loads.. wot else to do ?

[icecube]

[Gecko]

It sounds like your Msjtes40.dll is not correctly registered.

Quit Access if it is open.
Click Start, and then click Run.
Type the following line in the Open box, and then click OK:
regsvr32.exe C:\WINDOWS\system32\msjtes40.dll
(this is assuming that you have installed windows in the above path line if not adjust accordingly)
Restart Access and try to open a database table it should work now.

[robbro]

gecko thanks mate. your just a genious as always . thanks both for ya help though i can do my uni work now