Prev: Automatic Annual Leave - stevie PIMPS again
Next: MS Access Table Design Look Up???
From: Stewart Berman on 4 May 2010 16:26
John W. Vinson <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote:

>On Mon, 03 May 2010 16:26:31 -0400, Stewart Berman <saberman(a)nospam.nospam>
>wrote:
>
>>Here's two threads I happened to save references to:
>>o7en55h3l4hjajg9vnjd18fg3ari83icnq(a)4ax.com
>>qds5n4pqhv5f5btea2ko2rj1nk0e9ut1b7(a)4ax.com
>>
>>Do you want me to search for some more?
>
>Can't read these from Agent but I apologize and I'll take your word for it. MS
>engineers do sometimes reply, and I'm missing them (perhaps because I skip
>over many answered threads).

X-Tomcat-ID: 38198238
References: <o7en55h3l4hjajg9vnjd18fg3ari83icnq(a)4ax.com>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
From: changliw(a)online.microsoft.com ("Charles Wang [MSFT]")
Organization: Microsoft
Date: Tue, 14 Jul 2009 07:52:08 GMT
Subject: RE: Unable to Append All the Data to the Table
X-Tomcat-NG: microsoft.public.access.queries
Message-ID: <KcpQHgFBKHA.1156(a)TK2MSFTNGHUB02.phx.gbl>
Newsgroups: microsoft.public.access.queries
Lines: 58
NNTP-Posting-Host: tk2tomimport1.phx.gbl 10.230.18.247
Path: TK2MSFTNGP01.phx.gbl!TK2MSFTNGHUB02.phx.gbl
Xref: TK2MSFTNGP01.phx.gbl microsoft.public.access.queries:378931

Dear Stewart,
Welcome to Microsoft MSDN Managed Newsgroup.

Regarding this issue, based on my research, two main reasons for the
occurrence of the above error message are discussed below:
1. Appending of the records that were the primary key values
2. Violating referential integrity rules for a relationship defined between
tables

I recommend that you first try using an built-in repair utility ("Compact
and Repair") provided in MS Office. To use the utility, you will need to
follow these steps:
1. Go to the Tools menu, select Database Utilities and then click Compact
and Repair Database.
2. Locate and then click the database in the "Database to Compact From"
dialog box, and then click Compact.
3. Select an appropriate folder location for the new file in the "Compact
Database Into" dialog box, type a unique name for the file and then click
on Save.
In most cases, the inbuilt utility resolves your problem. However, if the
built-in utility is unable to resolve the issue, then you will need to opt
for powerful Access Repair utility. These Access Database Repair
applications employ effective scanning methods to completely scan and
repair the corrupted database. These applications can recover and restore
inaccessible Access databases (.mdb and .accdb).

Before you take the above action, please first save a copy of your access
database. In case it does not help, I recommend that you send me
(changliw_at_microsoft_dot_com) a copy of your Access database and the text
file to me so that I can quickly reproduce your issue and perform effective
research on it.

Thank you!

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg(a)microsoft.com.
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
First  |  Prev  | 
Pages: 1 2 3
Prev: Automatic Annual Leave - stevie PIMPS again
Next: MS Access Table Design Look Up???