Connecting MS Access to MySQL

Demo on connecting MS access as a client to MySQL server

---

Closed Caption:

alright so welcome people back to I
plans of technology- poor vast and onion
soubise shall be demonstrated hold with
three degrees on was thinking you need
to rest the microphone on settings for
driver great so like we said we're going
to be continuing to show all we wanna
have a web server running so I've
already have one installed and as you
can see it's green and it's online and
everything you have all these services
running and I'm going to launch my admin
PHP myadmin ok so as we can see here the
operating view is in place and we have a
few liter pieces already in Greece will
be the insulation but for the purposes
of this the more I i propose to
importantly to these instead of using
these ok so i click on import and my
brows already have a database setup is
called products Ryan Anderson is an SQL
query file
alright and this is really important
into the current silma I bros
i selected and it's already entered the
air we all the rest size seven falls out
cool nice and as you can see here it
says import has been successfully
finished that one query is executed
product that SQL and you can see on this
idea about start SQL is now included in
the list of databases that are available
ok so no I you can produce is the
trapeze selected from here we can see
right let's select have a look
so we jump to the database products in
the database products is one table and
their seven rows with different things
and those brows that need to be so we
can see it
nice so here now we have a table as it
but we imported and as you can see we
could even pull up the table to show you
know what was in that evil so if we see
anyone or bad
this is what we this is what we imported
into the databases that is a standard
SQL query where we protein job will be
to recent example was there and then we
recreate it to use between products and
creative of books books and products
still what won't be the ID and stuff to
be missing how wanted increment and the
primary key and we put the other one
feels like title category ISBN number
and basically trapped me in certain into
the team so you can see inception 12345
seven records and if you think back you
can see is 1234567 records ok so we
successfully imported that s LT will and
populate the database is a useful way to
do it and about been to one record at
that time you have hundreds of records
in Connecticut as well as simple query
and imported into my admin RPC my admin
which is really I cancellation of mysql
okay no so in order to link this to
access you need to launch access to all
programs Microsoft Office
Oh need to launch access mr Gilmore we
surrounded ministry told say gasps nice
and we can pull up was split up I am to
be Therese is obviously the Reese's well
as against is empty right but we want to
relax aliza using a wee CBS is a link to
the source by created and linked table
see okay and when you mention because
the machine data sauce and we mean in
here we select stumpy the sauce thanks
and school out
select the drive 190 install the driver
before so it's here next finish then we
can believe the sauce
I mean many people in sports but also
the table scholar products
alright and use his route open up here
in the celebrity to be easy at least all
products and let's test it
nice gestures are stories that connect
myself successful ok and we have the
products connection again i'm going to
be using it
thanks i'm busy table that's on there
I'm gonna feel it back to table you can
see that the table is pulled from bonus
i think the table is books back to hear
select box
okie and there we have a link to the
asset in this is all so just to show
that we actually connected on the double
click here there we have a full table
expand this so in the books that we
added my great inventor mysql server and
SQL Server and you cannot have a
connection to those books so so we're
going to be seen in that we could update
the server as we can see these survived
seven records so when I selling records
let's see if we can do some listening to
some data from right and this table here
and there so let's grab a couple of
books here on this book is pulled and to
scalp electrode I am TV
and shines ok category there's our
international relations is called
international relations i am T that is
being a number its ass p.m. happens to
be your country was in common mall m04
5427 tree and that one is hanging to be
record eat and then we go economic arm
girl this is the sparkle school
economics responded to our category a
week on and it's ISBN number it's 970
1992 field 641 hospital long 6416 ok so
we have happened in so we go back to
this our view it
books there we have it be records are
updated into an intrusive of the DC
records this is all the ideas run and
what we've shown is that we and populate
from an access client having connected
to heat abuse by odbc connector we can
actually how I a data entry clerk just
open a microsoft access link them to the
Silver Eagles already over there and you
can start entering data this could
really a library system or something so
that was that was almost indeedy
the demos of Hauser operate within a
client-server system uses an access
black iron and my ad piece we my add new
by a mysql mysql to populate Peter
pieces on a supe