Table already created

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Every time that I close Access or my database it tells me
that the table 'TempMSysAccessObject' Already exists. I
don't have a table called that and it wont let me compact
my database without doing something about it. Does anyone
know how to get rid of this error?
 
Hi Dan,

See: PRB: "Table 'TempMSysAccessObjects' Already Exists" Error Message May
Occur While Using the Compact and Repair Database Utility
http://support.microsoft.com/?id=818099

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."


--------------------
| Content-Class: urn:content-classes:message
| From: "Dan" <[email protected]>
| Sender: "Dan" <[email protected]>
| Subject: Table already created
| Date: Tue, 17 Feb 2004 15:30:22 -0800
| Lines: 5
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcP1rgOABPYSDyyxRq65SRakepeuqg==
| Newsgroups: microsoft.public.access.forms
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.forms:255601
| NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
| X-Tomcat-NG: microsoft.public.access.forms
|
| Every time that I close Access or my database it tells me
| that the table 'TempMSysAccessObject' Already exists. I
| don't have a table called that and it wont let me compact
| my database without doing something about it. Does anyone
| know how to get rid of this error?
|
 
Every time that I close Access or my database it tells me
that the table 'TempMSysAccessObject' Already exists. I
don't have a table called that and it wont let me compact
my database without doing something about it. Does anyone
know how to get rid of this error?

It's one of the hidden System tables. Your database is probably
corrupt; create a new, empty database and use File... Get External
Data... Import to import every valid table. This will give you a clean
set of systems tables.
 
Back
Top