Re: MyODBC 2.50.37 and Access 2000

2001-07-14 Thread Sinisa Milivojevic
Venu Anuganti writes: > Hi Kevin > > Can you please send us the ODBC trace generated by MyODBC as well as ODBC DM > ? > > Thank you > Venu Anuganti Hi! This was simply a case that Access table did not have auto-increment and timestamp columns in it. Unfortunately, there are some restrictions

Re: MyODBC 2.50.37 and Access 2000

2001-07-13 Thread Kevin Smith
to explain this to my project manager, the thought was daunting. Thanks again. Kevin - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, July 13, 2001 10:43 PM Subject: RE: MyODBC 2.50.37 and Access 2000 > I

Re: MyODBC 2.50.37 and Access 2000

2001-07-13 Thread Dan Nelson
In the last episode (Jul 13), Kevin Smith said: > Yes, each record has a primary key, but not a timestamp. Does this > make any difference? > > This also happens with my Unix machine which has MySQL installed on > it. I have had the problem for about a year, but now that I'm > starting to use M

Re: MyODBC 2.50.37 and Access 2000

2001-07-13 Thread Kevin Smith
CTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, July 13, 2001 10:43 PM Subject: RE: MyODBC 2.50.37 and Access 2000 > I have followed two very simple rules and it has always fixed this > problem for me. First, every table must have an auto_increment field > as the primary key. I alwa

RE: MyODBC 2.50.37 and Access 2000

2001-07-13 Thread JHDrexler
I have followed two very simple rules and it has always fixed this problem for me. First, every table must have an auto_increment field as the primary key. I always name use the first field and I name it Serial. Second, every table must have a timestamp field. I use the second field and I

Re: MyODBC 2.50.37 and Access 2000

2001-07-13 Thread Kevin Smith
work, this is a real bug bear and one that I'm surprised no one knows about. Thanks, Kevin - Original Message - From: "Joshua J. Kugler" <[EMAIL PROTECTED]> To: "Kevin Smith" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, July 13, 2001

Re: MyODBC 2.50.37 and Access 2000

2001-07-13 Thread Joshua J. Kugler
This may be a silly question, but since you didn't state it in your e-mail: does each record have a primary key AND a timestamp field? j- k- On Friday 13 July 2001 01:24, Kevin Smith wrote: > Hi All, > > I've installed MySQL 3.23.39 on my Windows 2000 Pro Server and I am > currently dev

Re: MyODBC 2.50.37 and Access 2000

2001-07-13 Thread Venu Anuganti
Hi Kevin Can you please send us the ODBC trace generated by MyODBC as well as ODBC DM ? Thank you Venu Anuganti - Original Message - From: "Kevin Smith" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 13, 2001 2:24 AM Subject: MyODBC 2.50.37 and Access 2000 > Hi All, > >

Re: MyODBC 2.50.37 and Access 2000

2001-07-13 Thread Kevin Smith
Hi, I didn't get a reply to this, so I guess no one knows, or, it's on the wrong forum. Can any set me straight on this? Cheers, Kevin - Original Message - From: "Kevin Smith" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 13, 2001 10:24 AM Subject: MyODBC 2.50.37 and