Linking MS Access to MS SQL Server 2008 R2

A demonstration of how to connect a client application to an application server.

---

Closed Caption:

welcome to I tech 285 kinds of the
technology
- Paul Bastian and what we are about to
embark on is an explanation of whole to
link
microsoft access to Microsoft SQL Server
2008 r2 utilizing a movie DC tribal
so as previously mentioned we're going
to be demonstrating how to connect our
clients of a connection from using
access as a client
- I spikes of stl super I super
application
so if you care to connect and so most
administrators to connect directly to a
silver so they don't have control over
overall our updates in solution
the Asians and they like to the soup on
so right now we have this particular
super running on the windows seven
beasts
we want to eat the pieces and we have
several the two pieces already installed
this particularly cities here was
created to then inform and it was
populated we look at the tables so we do
create a table cause to the in full see
it was
we're just checking to see what DJ is
already in here
alright so as we can see there is a
table already in our database this is on
silver that we already have some
information in there like a student ID
loose in the last name and ID taboo
tester tester school that we have
records on the super
alright so next what we do is we launch
Microsoft back
so this accidents run as administrator
yes we can you can you can actually go
out and reopen a deeper peace
so again we go to external data to order
to use the access piece link to be just
as my creative writing table so
ok the machinery to source select new
we're going to be collect out connecting
use the data source
ok also stumbles you system
I know as you can see selecting system
data source creates a video source which
is specific to this machine usable by
any user who moves on to be special next
right now we're looking for the driver
and the SQL triangle is equal to X so -
so we asked me in this travel we can
name it
les limites to access the system an
update here
no well to sell my products or it's
going to be safe
max you can be default and all of these
things come here changing the default to
be useful
change it to what we call it student
that was an email to table on the Detex
x everything else remains the same same
finish
testing the source
I don't see test completed successfully
ok ok here come out of that window and
as you can see our student update
connection is he okay
and here's our student database object
close to the forms
ok and there we have it
it's linked to this is linked in the
tables so my client a client doesn't
have to create their own tables and then
have to update the tsuba any client mr.
don't remember any machine
I guess connect to lose silver and how
all the tables necessary to populate
so there we have it you have the student
ID is here and this distance that
already exists in the database so we can
now start populating this from the
client
normal detention block this has been
some data 450
a bill what was what eat
- 12 months
i D
I the let's put another one for good
measure four five six seven
so get some water
teens and here's me but January that's
put on your surgeon then
so once i get back to be two weeks
Rose there we have it we have just
populated betta only database only sell
it so as you know
to me to get it