Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Question Unanswered: Linking Oracle memo field to access

    Hi,

    Any one how knows someting about linking a Oracle tabel whit a memo fileld to MS-Access. When i try this the memo field i my linked tabel only contains stranges values like binary text or something.

    Regards
    Lasse

  2. #2
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Wink Do i understand it right

    Do you link a Orcale TABLE to 1 Memo field


    or a Oracle memo / text field to a Access memo / text field

  3. #3
    Join Date
    Nov 2003
    Posts
    3

    Re: Do i understand it right

    Originally posted by Marvels
    Do you link a Orcale TABLE to 1 Memo field


    or a Oracle memo / text field to a Access memo / text field
    Hi, Tankt for your interest.

    This is the case.

    I have linked one oracle table to my MS-Access db. The Oracle table that i have linked have a field of the type memo (when i check the table in design mode from MS-access it tolds me that it is a memo-field.

    (The name of the oracle field is LONGDESCRIPTION)

    When i try to open the linked table in MS-Access i only see som strange values (like binary symbols)

    When i tried to run a query from Oracle sql* plus direktly to the table i got the information from the field.

    It seams if MS-Access not could handeld Oracle memo-fields, do you know if there is any work around for this problem.

    Regards
    //Lasse

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •