[dba-SQLServer]ODBC connection - Is this normal

Very normal.  It's also normal to drop Access as your FE and do
everything using something more robust like C#, C++, or even VB.

-----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 12:22 PM
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