RE: access 95 and MySQL - Venu - com.mysql.lists.myodbc

3 messages in com.mysql.lists.myodbcRE: access 95 and MySQL

From	Sent On	Attachments
Richard Dobson	11 Oct 2001 10:15
Venu	11 Oct 2001 10:39
Venu	15 Oct 2001 10:31

Subject:	RE: access 95 and MySQL
From:	Venu (ve...@mysql.com)
Date:	10/11/2001 10:39:24 AM
List:	com.mysql.lists.myodbc

Hi Richard !!

-----Original Message----- From: Richard Dobson [mailto:rich...@hotmail.com] Sent: Thursday, October 11, 2001 10:16 AM To: myo...@lists.mysql.com Cc: rich...@hotmail.com Subject: access 95 and MySQL

Hi, I can connect to MySQL using MyODBC from Access95 and can link tables but when it comes to exporting the tables from access into MySQL I am presented with the following error message:

[TCX][Myodbc] Unknown table 'tablename' (#1051)

This suggests that it can't find the table within the access DB. This DB is replicated but apart from that there is nothing weird about it. Anybody any ideas?

As an alternative I have tried to create an SQL pass through query in Access. Is it possible to append a MySQL table with data from an access table?

i.e insert into Ph_ABP(Member_ID) select Member_ID from c:\Windows\Desktop\db1.ABP

It's complaining that there is a syntax error in the path name.

Any help woukld be greatly appreciated cheers

Coming to the export of tables, am not very much sure why you get the Table error. The funny thing looks to be, Access 95 is trying to execute DROP TABLE before it is exporting it to the server, this might be causing your table error. Becuase your log shows that the error occured at DROP TABLE 'Sex'.

So, as a tril you can do the following work-arounds:

1. Just for testing, add a dummy table with the same name and in the server first, and then re-export the table from Access-95, and see whether it helps in way. This is to know that the problem is with DROP TABLE from access. I suspect it shouldn't be the real case.

2. The second option is to use other third party tools to do this job, so that they understand MyODBC better than Access. The tools that does import or export from access to server is:

*MySQL-Front *DbTools, you can find more on this from http://www.mysql.com/downloads/contrib.html

3. The third option is to upgrade to the latest MSAccess version.

Also, I saw you sending a mail to other MySQL mail ids, regarding thisr problem. In the future, when you have anything regarding MyODBC, it should be to myo...@lists.mysql.com, any for any MySQL related, send it to mys...@lists.mysql.com