>>>>> "David" == David Button <db@stripped> writes:
David> I am new to ODBC. I have Access97 on my local pc and am exporting to
David> MySQL on a remote server using ODBC. I have 3 queries which I can't
David> resolve from archives/manual.
David> 1) Although I'm setting a primary key in my Access dbase, this is not
David> 'appearing' in the mysql database. Do I have to this this 'manually'
David> after export?
Sorry, I don't know the answer to this one; Try doing a MyODBC trace
file (or start mysqld with --log) and check what commands Access sends
to the MySQL server; There is always the possibility the Access
doesn't send MySQL the information about the index!
David> 2) I want to export a currency or integer field with fixed two decimal
David> places but either end up with 4 decimal places or none in the mysql
Same answer as above; You must find out what statemens Access is
sending to MySQL to know what is going wrong.
David> 3) ODBC export does not appear to overwrite existing tables. I first
David> have to delete them on remote server before export. Is there a way round
I don't think so (this is an Access problem)
David> David Button