Eric Barro
ebarro at afsweb.com
Mon Oct 6 12:34:03 CDT 2003
Yes I have seen this behavior too. You would be better off manipulating the recordset via code much like you would do with an ASP front end and SQL back end or have some relinker code when you open the db or on demand when you make changes. --- Eric Barro Senior Systems Analyst Advanced Field Services (208) 772-7060 http://www.afsweb.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of John Colby Sent: Monday, October 06, 2003 10:22 AM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer]ODBC connection - Is this normal I used a n ODBC connection to link my existing FE to my Client Billing data exported to SQL Server. I am adding ToDo list functionality and have discovered that when I build a table and link it to the FE, if I go back in to SQL Server and add a new column, that column doesn't show in the BE. I have to delete the link and relink before I can see the new column. Is this normal? It's almost as if the link is a query of specific fields. John W. Colby www.colbyconsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.516 / Virus Database: 313 - Release Date: 9/1/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.516 / Virus Database: 313 - Release Date: 9/1/2003