How did you originally populate the MySQL database with this table in question? Did you export the table via MS Access and load the data with either LOAD DATA or mysqlimport? ... Out of curiosity why did you use Access to create and populate the tables, export them to MySQL and are using Access to view the tables?
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 3/4/04, 2:47:51 PM, Steve Siesel <[EMAIL PROTECTED]> wrote regarding Re: MS Access and MySql: > The Database was originally made in Access.... > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "Steve Siesel" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Thursday, March 04, 2004 3:35 PM > Subject: Re: MS Access and MySql > What is `special` about this one? If you are using ODBC links why are you > needing to convert the table? MS Access is merely your GUI to the > underlying data. > >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< > On 3/4/04, 2:28:31 PM, Steve Siesel <[EMAIL PROTECTED]> wrote regarding Re: > MS Access and MySql: > > I am using ODBC links to move the data. There were multiple > > tables in the database and this is the only one effected. > > Steve > > ----- Original Message ----- > > From: <[EMAIL PROTECTED]> > > To: "Steve Siesel" <[EMAIL PROTECTED]> > > Cc: <[EMAIL PROTECTED]> > > Sent: Thursday, March 04, 2004 3:03 PM > > Subject: Re: MS Access and MySql > > Are you using ODBC Links or are you importing the table into MS Access > > from MySQL? Are there unique constraints on the table to prevent > > duplicate data from being entered? > > >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< > > On 3/4/04, 1:57:15 PM, Steve Siesel <[EMAIL PROTECTED]> wrote regarding MS > > Access and MySql: > > > Greeting to the list. > > > I am running MS Access as a front end to data stored on MySql in > > > a Redhat 7.3 box. > > > I have about 95% functionality so far! > > > (The Database is of a Youth Soccer league). > > > I am having one problem though with one of my tables. > > > The table seems to double itself when I transfer/convert/export > > > into MySql. The table holds 345 records and when I view it in MySql > > > there are 690. > > > I have tried Exporting and I have used various converters also. This one > > > table > > > is my biggest problem so far. > > > Does anyone have any suggestions? I am located near Tampa, Fl If someone > > > would > > > like to offer any assistance. > > > Thanks > > > Steve > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
