RE: Paste Append



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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"jrizzo77" wrote:

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?

.



Relevant Pages

  • RE: Change/Save to aggregate query shuts down Access
    ... I'm thinking that the database file is corrupt. ... The query runs fine, and modifications can be made and run ...
    (microsoft.public.access.queries)
  • Re: Corrupt form...or so it seems
    ... Tracy, 2 things come to mind from your description. ... Is it possible that the query that the ... > query which pulls from the now corrupt customer table. ...
    (microsoft.public.access.forms)
  • Re: Database Alternative
    ... > Its in a beta state and I want to inform you some test ... Hi bumerang, ... A query for one indexed object in 10,000 objects takes 1.1 seconds. ... The indexed database file has a size of 470kB. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Corrupt form...or so it seems
    ... > <The first is you stated that the form is based on a query. ... > the form that I think is corrupt is the Customers Table. ... it just happens to be where the first error message appears ...
    (microsoft.public.access.forms)
  • Re: Corrupt form...or so it seems
    ... <The first is you stated that the form is based on a query. ... the form that I think is corrupt is the Customers Table. ... Already set to break (an error message could very well be popping up ...
    (microsoft.public.access.forms)