Table Relationship in ADP

P

Peter

We connect an ADP to SQL Server 2000.

There is no table relationship being setup in SQL Server.
Is there any way for us to define the relation between a
couple of tables in Access locally ? OR the table
relationship will be updated in SQL Server as well ?

Thanks
 
N

Norman Yuan

In Access ADP project, you can easily create relationship between tables by
using Diagram. Actaully Diagram is SQL Server object, you cannot create
relationship locally saved in ADP file (Forms, Reports, Macros and Modules
are local object saved inside ADP file).
 
P

Peter

In this way, if I create an Access database and link to
the tables in SQL Server via ODBC. Is it possible for me
to create local table relationship ?

Thanks
 
Top