Error on opening Table

I set up a temporary table to be able to copy names &
values via the internet to excel and then into my
database. I only used it once, and now whenever I click
on it, I get the error report to send to Microsoft. I am
trying to delete this table and Access won't let me.
I did try using the Table Analyzer and I got the
message "Method 'OnParentNotify' of
object '_Form_NORM_frmPage1' failed. I don't have a page
for this or Form set up for this table.

Please help me delete this table. I can't even use the
Compact and Repair database because it gives me that error
report to send an error report to Microsoft.

Thank you!

Hi Sherrie,

Try importing your ALL your objects into a new database with the exception
of your corrupted table. Example:

- Create a blank new database
- Within the blank new database select the menu option File Get External
Data Import
- Select your original database file
- Within the Import Objects dialog click "Select ALL"
- Deselect your corrupted table
- Click Import

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


Regards,

Eric Butts
Microsoft Access Support

"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: "Sherrie"
| Sender: "Sherrie"
| Subject: Error on opening Table
| Date: Tue, 11 May 2004 11:45:38 -0700
| Lines: 15
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcQ3iCcKMR+8gy0lQiCzTSvBaDOHPg==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.tablesdbdesign
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.tablesdbdesign:79214
| NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| I set up a temporary table to be able to copy names &
| values via the internet to excel and then into my
| database. I only used it once, and now whenever I click
| on it, I get the error report to send to Microsoft. I am
| trying to delete this table and Access won't let me.
| I did try using the Table Analyzer and I got the
| message "Method 'OnParentNotify' of
| object '_Form_NORM_frmPage1' failed. I don't have a page
| for this or Form set up for this table.
|
| Please help me delete this table. I can't even use the
| Compact and Repair database because it gives me that error
| report to send an error report to Microsoft.
|
| Thank you!
|