Paste Append

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jrizzo77 - 13 May 2008 17:25 GMT

I am having issues with Paste Append. whenever I try to paste append
and then move to another record my DB shutdown. I am trying to do
this directly into the table. Anyone have this issue or know what
might be causing it?

Reply to this Message

Jerry Whittle - 13 May 2008 20:13 GMT

Both of your posts lead me to believe that the database is corrupt. Try
creating a new database file and importing everything from the old to the
new. If something won't come over, it probably was corrupt.

If the OLE field is still a problem, create a Make Table query based on the
problem table and exclude the OLE field. After running the query
successfully, delete the original table and rename the new one to the
original's name. You may have to recreate any primary keys, indexes, or
relationships.

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> I am having issues with Paste Append. whenever I try to paste append
> and then move to another record my DB shutdown. I am trying to do
> this directly into the table. Anyone have this issue or know what
> might be causing it?

Reply to this Message

Alan - 17 May 2008 04:46 GMT

On May 14, 3:13 am, Jerry Whittle
<JerryWhit...@discussions.microsoft.com> wrote:

> Both of your posts lead me to believe that thedatabaseiscorrupt. Try
> creating a newdatabasefile and importing everything from the old to the
[quoted text clipped - 15 lines]
>
> - Show quoted text -

Hi,

If you can't handle the repair by yourself, I think you can try a
utility called Advanced Access Repair to repair your Access MDB file.
It works rather well for my corrupt Access MDB files. Its web address
is http://www.datanumen.com/aar/ Hope this helps.

Alan

Reply to this Message

Douglas J. Steele - 17 May 2008 12:31 GMT

Gee, I'd have expected an employee of the company to be a little more
positive than " I think you can try a utility..."

Please, stop your unwanted spamming of these newsgroups. As it is, you've
practically guaranteed that no MVP will ever recommend your product.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

On May 14, 3:13 am, Jerry Whittle

Hi,

If you can't handle the repair by yourself, I think you can try a
utility called Advanced Access Repair to repair your Access MDB file.
It works rather well for my corrupt Access MDB files.

Alan

Reply to this Message

Rate this thread: