>Hello everyone,
>
>I am doing the following :
>
>
>IF !USED('euc_database_view')
> USE euc_database_view IN 0
> SELECT euc_database_view
>ELSE
> SELECT euc_database_view
>ENDIF
>SELECT Sales_Transaction
>APPEND FROM DBF('euc_database_view')
>
>The problem is that the above code only append 100 records instead of 600.
>
>Could it be that I have to give more time to the remote view to open before I append???.
>
>Any help would be appreciated.
>
>
>Sergio Ortiz
What are your settings for the view? Are you getting pieces back or all the data at once? Is the access data through a wan or is it on your lan?
I am getting an error in trying to set up an ODBC with access and say "Oh Well." Sorry that I can't help you out any more.
But you should be able to tell the connection how you want the data deliverd to you, parts or in whole. Secondly a go bott in a remote view will make the driver fetch more data.
Hope this helps.
__Stephen