Martin Caro
mcaro at bigpond.net.au
Mon Jul 19 07:45:23 CDT 2004
Michael Using an append query on an ODBC/Linked table. I need to retrieve the record when the user exits using a composite UserID and LoginInTime key and insert a logoff time however, the value I have stored in a global variable has seconds and the value stored in the table has been rounded to full minutes so I'm never going to retrieve the correct record unless the login was actually on the full minute. Martin ----- Original Message ----- From: "Michael Brösdorf" <michael.broesdorf at web.de> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Monday, July 19, 2004 10:21 PM Subject: AW: [AccessD] Seconds Missing How exactly are you trying to write the time to sql server (ODBC/Linked table, ADO, etc.)? Michael -----Ursprüngliche Nachricht----- Von: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von Martin Caro Gesendet: Montag, 19. Juli 2004 13:30 An: Access Developers discussion and problem solving Betreff: [AccessD] Seconds Missing Hi Folks I have spent some time in the archives and reviewing past date/time issues looking for a fix for this problem: I grab the user login time using NOW() and save it to an SQL table however any seconds apparent in Access always end up as :00 being save in my SQL table. I was using smalldatetime data type which I changed to datetime but without success. I have played with Format() a bit but maybe someone knows where my seconds have gone? Martin -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com