Thanks for the reply. I'm surprised you found this posting.
It's been up there since Jan. I'll try your suggestion
and let you know. Thanks again.
rt


>My deepest sympathies. Try this: use OBDC to
>configure
>an Access 2.0 data source. In VFP, create a remote
>view
>using this data source. Be aware that the
>2.00.2317 MS
>Access driver can only handle SQL statements that
>are
>less than 255 characters (Official MS Dogma);
>therefore,
>your code must be translated to SQL statements of
>255
>chracters or less. (I.e., an APPEND FROM xxx.dbf,
>where
>that dbf has more than 40 or so fields results in
>an
>OBDC error: Query Too Complex.) Best of luck.
>
>I currently have an open ticket with MS regarding
>what
>to do with dbfs that have more than 40 fields (the
>ones
>that cause the above error). They say to divide up
>the
>MDB table I am accessing with multiple remote
>views then
>use a container local view that looks at the other
>views.
>I welcome any suggestions as to how to APPEND FROM
>to this
>view, because as of right now, I get an some
>strange error
>regarding No Update Tables defined.
>
>__________________________________________________
>>I seem to be out of luck when it comes linking to
>>a table
>>stored in an Access 2.0 container. Access has an
>>attach
>>feature that works on Foxpro 2.X .dbf tables.
>>Does anybody
>>know a way of "attaching" the other way?
>>
>>
>