Arthur Fuller
artful at rogers.com
Thu Feb 27 08:09:13 CST 2003
I assume that you mean the SQL level default value rather than the Access level default. If so, I don't think you'll see it set until after you save the row. Same behaviour as ANPK values. -----Original Message----- From: dba-sqlserver-admin at databaseadvisors.com [mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of John W. Colby Sent: February 27, 2003 7:41 AM To: AccessD Cc: AccessD-SQLServer Subject: [dba-SQLServer]SQL Server default value not happening I upsized my client billing to SQL Server the other day. This morning I noticed that a couple of flag fields in my main time table are not being set to their default value. I went directly into EM and created a record in the table and the flags are correctly set there. I opened the ADP, opened the table there and entered a record, and the default value is NOT being set correctly there. Any ideas why the default values would work in EM but not in the ADP? John W. Colby Colby Consulting www.ColbyConsulting.com ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com