Text 2282, 40 rader
Skriven 2005-02-01 04:12:36 av Ellen K. (1:379/45)
   Kommentar till text 2260 av Antti Kurenniemi (1:379/45)
Ärende: Re: Anyone handy with Access and ODBC?
==============================================
From: Ellen K. <72322.1016@compuserve.com>

1.  Set up a DSN for the MySQL database. 2.  In Access, select Table | New |
Link 3.  When the file open dialog opens, select Files of Type ODBC Databases,
and select your MySQL DSN. 3.  Link to all the tables in the MySQL database.  
If it has a
password, be sure to check the "Save Password" box.

That's the whole story.   Now you can talk to both the Access tables and
the MySQL tables from the Access database, using VBA.   You can make a
saved query that updates the MySQL prices from the Access ones, and have your
VBA code call it.

Assuming the Access app is front end / back end, the back end one is the one
you link.

On Mon, 31 Jan 2005 09:54:06 +0200, "Antti Kurenniemi"
<antti@anttik.com> wrote in message <41fde3ed@w3.nls.net>:

>Hello hello hello,
>
>
>how's this: can I use VBA in Access to connect to another database through
>ODBC? What I'm after is, we have a client that has a webshop which uses a
>MySQL database, and they have an Access database which they use to manage
>the pricing and stuff (it's an old Access app which they'd like to keep),
>and currently they're typing the prices manually to the MySQL database - but
>I was thinking that it should probably be possible to connect directly from
>Access and just push the numbers to the other database.
>
>I tried googling a bit, but there were about 17 trillion hits, and most of
>them seemed to be about how to open a MySQL database with Access which is
>not what I'm after.
>
>Any ideas are welcome,
>Antti Kurenniemi
>

--- BBBS/NT v4.01 Flag-5
 * Origin: Barktopia BBS Site http://HarborWebs.com:8081 (1:379/45)