[AccessD] Access frontend/SQL Server backend

Tesiny, Ed EdTesiny at oasas.state.ny.us
Tue Oct 3 11:03:19 CDT 2006


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
 



More information about the AccessD mailing list