Re: MyODBC and Access: empty table works, filled shows errors

On Dec 17, 2007 9:12 PM, Mark Jansen <[email protected]> wrote:

Ah, a fellow Dutchman.... ;-)


> This is a n-to-n table, so multiple flexible relations. Lid is the Dutch
> word for 'member', so LidID is the MemberID (data of members stored in
> another table). 'FunctieID' refer to the sections of the club the
> members belong to (ranging from just 1 to many more).

(why tell me this ;-) )

> The problem is: when this table is empty, Access shows it perfectly to
> me. I can also easily add data, no problem at all. I just tried to enter
> three rows to test this.
>
> However, once I paste the current n-to-n relationship data into this
> table (n=260) and reopen the table, Access comes with an ODBC error and
> stops. All the columns show '#NAME' (actually '#NAAM' in Dutch). The odd
> thing is: Access shows the data perfectly right after pasting, but once
> I reopen the table, the trouble is back again.

Do you experience this as soon as there is data in the table, or did
you only try with no data at all or all data in the table? Do you have
some logging/tracing made by the myODBC dll or by ODBC itself?


Kind regards/Gegroet,

Frank

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]