[dba-SQLServer]SQL Server Upsize

Is it possible to enforce referential integrity between two tables where 
parent table is in Access and child table is in SQL Server?



>From: Martin Reid <mwp.reid at qub.ac.uk>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: dba-sqlserver <dba-sqlserver at databaseadvisors.com>
>Subject: [dba-SQLServer]SQL Server Upsize
>Date: Fri, 8 Aug 2003 13:37:41 -0700
>
>Folks
>
>I am looking at a large Multiple Back End DB. We are converting it to SQL
>Server/MSDE
>
>heres is one option. I would like comments pleaseeeeeeeeeee
>
>All data heavy tables will be moved to SQL Server 2000. Other smaller 
>tables
>whcih dont actualy contain a great deal of data will remain in Access MDB.
>We will then link the whole thing into the Front End. Move as much
>processing of this stuff to SQL Server, read only tto Pass Throughs.
>
>We are not using ADPS becasue of the recoding of the entire system. But it
>may be possible as there is a way to run DAO in an ADP.
>
>Anyone see any problems with this approach?
>
>Anyone care to suggest another?
>
>Any major problems joing local MDB linked tables to SQL Server Linked
>tables?
>
>Feel free to comment. I want to kick the options around.
>
>Martin
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online  
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963