Synchronisation with ms access

------_=_NextPart_001_01C582D3.0D8DC0D2
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

HI

=20

I have been checking out myodbc to link tables in mysql to msaccess. I
want to be able to update the original tables in ms access with the new
linked table created through myodbc. For example;

=20

=20

1. I have orders table in msaccess.
2. I used myodbc to first of all export the table to a mysql
database.
3. Now I have 'orders' in mysql and 'orders' in ms access.
4. I now create a linked table in ms access to link with the
'orders' table in mysql. This is automatically named 'orders1'.
5. I now have the following tables in msaccess. 'orders' and
'orders1'.
6. How do I link these two tables together. So, for example, if I
make changes in orders, the changes are reflected in orders1. These
changes will then reflect in the 'orders' table in mysql.

=20

Hope I am making sense, and I shall look fwd to your reply

=20

=20

Wasim Akhtar


------_=_NextPart_001_01C582D3.0D8DC0D2--

RE: Synchronisation with ms access

You do not need to link the 'orders' and 'orders1' tables in Access. Once
you have created a link to the table in MySQL, you just use this linked
table in your Access application. The simplest way to do this is to rename
the original table to 'orders_old' or something, and then rename 'orders1'
to 'orders'. (You can, in fact, simply delete the original Access table as
it is no longer required).

However, to ensure everything works smoothly, there are some other tings you
need to do in MySQL. At the very least you will need to define a primary
key, and add a timestamp field. Check out
http://dev.mysql.com/doc/mysql/en/programs-known-to-work-wit h-myodbc.html
for more details. Once you have made the necessary changes you will need to
refresh the Access linked table using the Linked Table Manager to ensure
Access picks up the changes.

-----Original Message-----
From: Wasim Aktar [mailto:Wasim@blue-flag.co.uk]
Sent: 07 July 2005 10:06
To: myodbc@lists.mysql.com
Subject: Synchronisation with ms access


HI



I have been checking out myodbc to link tables in mysql to msaccess. I want
to be able to update the original tables in ms access with the new linked
table created through myodbc. For example;





1. I have orders table in msaccess.
2. I used myodbc to first of all export the table to a mysql
database.
3. Now I have 'orders' in mysql and 'orders' in ms access.
4. I now create a linked table in ms access to link with the
'orders' table in mysql. This is automatically named 'orders1'.
5. I now have the following tables in msaccess. 'orders' and
'orders1'.
6. How do I link these two tables together. So, for example, if I
make changes in orders, the changes are reflected in orders1. These changes
will then reflect in the 'orders' table in mysql.



Hope I am making sense, and I shall look fwd to your reply





Wasim Akhtar


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org