John W. Colby
jcolby at colbyconsulting.com
Thu Feb 27 08:13:01 CST 2003
This particular case is the tblTime. I didn't check other tables. Understand that I did not upsize and end up with an ADP. I upsized the BE directly, then created an ADP and set up a connection to this database in SQL Server. Again, the default value can be seen, and works correctly when entering records directly in the EM, but in the ADP the default value doesn't show in the property and doesn't work when entering new records. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Martin Reid Sent: Thursday, February 27, 2003 8:49 AM To: accessd at databaseadvisors.com Subject: Re: RE: [AccessD] SQL Server default value not happening John What table is it. I still have the SQL version? Martin Martin WP Reid Information Services Queens University Belfast Tel: (02890) 273750 ---------------------- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 2196 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030227/68decdc1/attachment-0001.bin>