Professional Web Applications Themes

Access link to MySQL - MySQL

Have some users who are only comfortable in Access ... so thought of linking an Access database to an existing MySQL database. Linking worked fine ... when I double click on the table (linked) in Access - brings up data. When I got to alter a particular row, field ... I get: ODBC -- update on a linked table 'device' failed. [Microsoft][ODBC Driver Manager] SQL data type out of range (#0) I'm using MySQL 4.1.10 OS: Windows XP SP2 Access 2003 Anyone know what the issue is?...

  1. #1

    Default Access link to MySQL

    Have some users who are only comfortable in Access ... so thought of linking
    an Access database to an existing MySQL database. Linking worked fine ...
    when I double click on the table (linked) in Access - brings up data. When
    I got to alter a particular row, field ... I get:

    ODBC -- update on a linked table 'device' failed.

    [Microsoft][ODBC Driver Manager] SQL data type out of range (#0)

    I'm using MySQL 4.1.10
    OS: Windows XP SP2
    Access 2003

    Anyone know what the issue is?


    booner Guest

  2. #2

    Default Re: Access link to MySQL

    booner (com) wrote:
    : Have some users who are only comfortable in Access ... so thought of linking
    : an Access database to an existing MySQL database. Linking worked fine ...
    : when I double click on the table (linked) in Access - brings up data. When
    : I got to alter a particular row, field ... I get:

    : ODBC -- update on a linked table 'device' failed.

    : [Microsoft][ODBC Driver Manager] SQL data type out of range (#0)

    : I'm using MySQL 4.1.10
    : OS: Windows XP SP2
    : Access 2003

    : Anyone know what the issue is?

    I would compare each column definition as seen in access to the same
    column as seen in mysql.

    I suspect you'll find that the definition of a column as seen in access
    will have a different capability than the corresponding column as seen in
    mysql.

    So, for example, if access thinks a number column called THE_PRICE has 32
    bits and mysql thinks it has 16 bits then any number access sends will be
    too large for mysql.

    I guess that this would be most likely for any kind of generic data types
    like NUMERIC or TEXT, but I would check all the columns.


    $0.10

    Malcolm Guest

  3. #3

    Default Re: Access link to MySQL

    There are no tables in Access - it is linked to the mysql tables. How can
    there be a mismatch?


    "Malcolm Dew-Jones" <victoria.tc.ca> wrote in message
    news:victoria.tc.ca... 


    booner Guest

  4. #4

    Default Re: Access link to MySQL

    booner (com) wrote:
    : There are no tables in Access - it is linked to the mysql tables. How can
    : there be a mismatch?

    (Oh dear , top posting, oh well)

    When I link an external table (via ODBC) to access then the linked table
    appears in the same list as all the other tables within access.

    From within access I can open the table in design view and see the column
    definitions.

    In a sample table that I am looking at right now, Oracle has a column
    defined as VARCHAR2(2000) whereas access says it is a "Memo" column.

    The Oracle column can hold upto 2,000 characters, whereas the access says
    it is a Memo and can hold about 60,000 characters. I make a minor change
    to the data and it saves OK. Then I paste a string about 8,000 bytes long
    into the field in access. Access allows this because it thinks the field
    can hold a lot of data. But when I try to save the data then Oracle
    complains with an error similar to yours.


    : "Malcolm Dew-Jones" <victoria.tc.ca> wrote in message
    : news:victoria.tc.ca...
    : > booner (com) wrote:
    : > : Have some users who are only comfortable in Access ... so thought of
    : > linking
    : > : an Access database to an existing MySQL database. Linking worked fine
    : > ...
    : > : when I double click on the table (linked) in Access - brings up data.
    : > When
    : > : I got to alter a particular row, field ... I get:
    : >
    : > : ODBC -- update on a linked table 'device' failed.
    : >
    : > : [Microsoft][ODBC Driver Manager] SQL data type out of range (#0)
    : >
    : > : I'm using MySQL 4.1.10
    : > : OS: Windows XP SP2
    : > : Access 2003
    : >
    : > : Anyone know what the issue is?
    : >
    : > I would compare each column definition as seen in access to the same
    : > column as seen in mysql.
    : >
    : > I suspect you'll find that the definition of a column as seen in access
    : > will have a different capability than the corresponding column as seen in
    : > mysql.
    : >
    : > So, for example, if access thinks a number column called THE_PRICE has 32
    : > bits and mysql thinks it has 16 bits then any number access sends will be
    : > too large for mysql.
    : >
    : > I guess that this would be most likely for any kind of generic data types
    : > like NUMERIC or TEXT, but I would check all the columns.
    : >
    : >
    : > $0.10
    : >



    --
    Malcolm Guest

Similar Threads

  1. MS Access with Mysql link table connection failed
    By pelhughes in forum Coldfusion Database Access
    Replies: 3
    Last Post: July 3rd, 11:13 PM
  2. MySQL Communication link failure
    By rpmon in forum Coldfusion Database Access
    Replies: 1
    Last Post: June 20th, 01:03 PM
  3. PHP+MySQL, link.
    By tricks in forum PHP Development
    Replies: 3
    Last Post: September 29th, 07:56 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139