Gustav Brock
Gustav at cactus.dk
Tue Oct 3 12:09:42 CDT 2006
Hi Ed The relations are not lost, they are defined at the SQL Server. However, in Access they may not be displayed as is the case for JET tables. Be sure, when linking the tables of the server, to specify which field(s) represent(s) the primary key if the linking wizard asks for this. /gustav >>> EdTesiny at oasas.state.ny.us 03-10-2006 18:03:19 >>> Dear List, This is an elementary question as I know almost nothing about SQL Server. A colleague is developing a web-based ColdFusion application using SQL Server. I would like to access the data through an ODBC connection using Access as the frontend. I was able to get at the tables but the relationships between the tables were lost. Is there a way you can preserve the relationships or should I be trying to access the data by another means? MTIA Ed Edward P. Tesiny Assistant Director for Evaluation Bureau of Evaluation and Practice Improvement New York State OASAS 1450 Western Ave. Albany, New York 12203-3526 Phone: (518) 485-7189 Fax: (518) 485-5769 Email: EdTesiny at oasas.state.ny.us