[AccessD] MYSQL and msaccess

fixed....
added a new line in my.ini
lower_case_table_names=2

and a much pretty synchronization program like: Data Sync For MYSQL

thank's for your time
/kostas

-----Αρχικό μήνυμα----- 
From: Kostas Konstantinidis
Sent: Tuesday, March 11, 2014 9:47 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] MYSQL and msaccess

Hi guys,
I have some problems with the mysql connection and how to make a
synchronization between two databases.
So I took the liberty to write to you in case you have any good idea.
I have already migrate my access, building an mysql database on an external
server (tables, views, queries etc etc...)
It works fine online but while I am trying to add or change data with a
connected ms access via ODBC, it presents a very very very long delay (more
than 10-12 minutes for every search)...
For that reason I thought I would do the following: a new job, building a
local mysql database in which access via ODBC real responses quickly and
Then after working and finishing local my daily records updates to make a
synchronization between server and local files... It sounds as a good
solution but that’s the point all the problems begin
Names of all remote tables begin with uppercase such as MT_films,
ST_peoplefilm  or T_actors etc and as it seems MySQL Workbench 5.2 CE (which
I use for that) after synchronization converts everything with lowercase
(mt_films, st_peoplefilm, t_actors etc) something means that  the sql code
on views and queries doesn’t work...
any good idea?
Do you know any other mysql synchronization utility do that?

best regards
/kostas

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com