Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Attaching to Access 2.0
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00000140
Message ID:
00000998
Vues:
63
You're welcome. I hope it works. Let me know.

>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?
>>>
>>>
>>
>
Stephen Arbour
Systems Consultant
LAN Solutions, Inc.
sarbour@lansol.net

happy to ramble %)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform