SQL fields in Access

[DeanL]

Hi everyone,

Does anyone know if it's possible to link fields from a SQL Server db
into an Access db and if so then how? I have a number of users with
an Access db and they need a small amount of information that is
contained in a much larger SQL Server db but do not want "direct"
access to that db. Also, how would you link the fields to ensure the
correct record is displayed?

Many thanks, Dean...

[Rick Brandt]

Re: SQL fields in Access

DeanL wrote:

Hi everyone,
>
Does anyone know if it's possible to link fields from a SQL Server db
into an Access db and if so then how? I have a number of users with
an Access db and they need a small amount of information that is
contained in a much larger SQL Server db but do not want "direct"
access to that db. Also, how would you link the fields to ensure the
correct record is displayed?
>
Many thanks, Dean...

You don't "link fields". You "link tables".

Once the table links are created you could use a query that includes some
fields from the linked table and some from an Access/Jet table. I should
point out though that joining between tables from different sources is not
very efficient. If one or both of the tables is small it might not be a
problem.

As with any join between tables in a query there must a field or fields that
the tables have in common that can be used in the join. That is what
matches the records from the two sources up so you see the correct rows from
each table combined.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com