From: Gina Whipp on
Allan,

Just say thank goodness it works!

Happy Holidays!
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"ALLAN_ASHFORD via AccessMonster.com" <u56735(a)uwe> wrote in message
news:a0fcbd65df3d1(a)uwe...
> Maybe no longer stumped!!
>
> The table that I was trying to append the data to was, as you know, copied
> over from the fully functional database. As such it did contain well over
> 100,
> 000 redundant records. So I deleted the lot, did a repair & compact and
> hey
> presto everything appears to be OK. Only problem now is - trying to
> remember
> what I was trying to do when the problem hit!!
>
> Many thanks for all the input - have a great Xmas.
>
> Allan
>
> Gina Whipp wrote:
>>AccessVandal,
>>
>>In the macro yes those settings are required and the other options are not
>>an option. The subject line is kind of deciptive because those queries he
>>is referring to are actually, make table and update queries. Oddly,
>>enough
>>the macro runs in one database FE/BE set-up but not the other. He sent me
>>a
>>copy of the database and I was looking for some reference to a table or
>>query that existed in the one database but not the other and after
>>reviewing
>>MANY queries, found one. So now I am as stumped as he is.
>>
>>> Gina,
>>>
>>[quoted text clipped - 17 lines]
>>>>There
>>> snip...
>
> --
> Message posted via http://www.accessmonster.com
>