cannot create new tables in Access 97

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

juri.vlasov@etransa.at - 24 Mar 2004 18:39 GMT

I have been using Office 97 for years. Some days ago I
installed Access-2002 in a separate directory, without de-
installing Access 97. And now I see that I cannot create
new tables in Access 97, even if I create quite a new and
empty database. Well, I can copy tables, import tables
from other mdb-files, use "Create Table"-instruction in
Basic-procedures. But the button "New Table" just does not
react. Maybe, something was changed in the Registry after
Access-2002 installation?

Reply to this Message

Eric Butts [MSFT] - 24 Mar 2004 23:30 GMT

Hi,

Try reinstalling Access 97 as follows:

- locate all instances of MsAccess.exe
- rename them to MsAccess.exeOLD with the exception of MsAccess 2002 rename
it to MsAccess.exe2002
- rename the file Hatten.ttf to Hatten.ttfOLD
- Open the Control Panel and open Add/Programs
- Select Access 97 (or Office 97 which ever it is) and select Change
- Choose reinstall

Very possible that your install of 2002 stepped on 97.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.

Regards,

Eric Butts
Microsoft Access Support
ebutts@online.microsoft.com
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------

| Content-Class: urn:content-classes:message
| From: "juri.vlasov@etransa.at" <anonymous@discussions.microsoft.com>
[quoted text clipped - 25 lines]
| react. Maybe, something was changed in the Registry after
| Access-2002 installation?

Reply to this Message

- 25 Mar 2004 17:41 GMT

Dear Eric, thank you so much for your quick response. I
tried to follow your advice, but encountered,
unfortunately, another problem: Microsoft Office 97 Setup
does not want now to delete Access! Something happens, if
I try to do it, the program is just blocked, and I can
terminate it, only using Task Manager. I can delete all
other components, but not Access-97. I can also repeat the
previous installation of Office 97, in this case the
problem remains. So that, I deleted Office-XP (Access-2002
was the part of it) completely, but it did not help.
Thank you in advance for any more ideas!
Juri Vlasov, Vienna.

>-----Original Message-----
>Hi,
[quoted text clipped - 62 lines]
>
>.

Reply to this Message

Eric Butts [MSFT] - 28 Mar 2004 18:30 GMT

Hi,

I take it that you are unable to uninstall Access 97 (via Add/Remove
programs). If that is the case then try using the utility Eraser97.exe,
see: OFF97: Utility to Completely Remove Remaining Office 97 Files and
Registry Entries
http://support.microsoft.com/default.aspx?scid=kb;en-us;176823

Regards,

Eric Butts
Microsoft Access Support
ebutts@online.microsoft.com
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------

| Content-Class: urn:content-classes:message
| From: <anonymous@discussions.microsoft.com>
| Sender: <anonymous@discussions.microsoft.com>
| References: <12b9601c411c6$f7ceab90$a501280a@phx.gbl>

<h9xvd#eEEHA.2224@cpmsftngxa06.phx.gbl>

| Subject: RE: cannot create new tables in Access 97
| Date: Thu, 25 Mar 2004 08:41:57 -0800
[quoted text clipped - 111 lines]
| >
| >.

Reply to this Message

Gina - 25 Mar 2004 18:00 GMT

My two cents worth...

I would make sure Access/Office 2002 is installed and
behaving properly. Uninstall Access 97, refering to
Knowledge Base Article 163997 and then reinstall Access 97.

Do NOT try to use any part of Office 97 after you
completely remove Access 97 will cause problems AND reboot
between each install and reinstall and uninstall. Might
take some time but might be worth it!

>-----Original Message-----
>I have been using Office 97 for years. Some days ago I
[quoted text clipped - 7 lines]
>Access-2002 installation?
>.

Reply to this Message