I have a MS Access 2000 frontend and a SQL Server 2008 Express front end. I'm trying to insert a new record, and the time(0) data type always gives me problems. If I type this in directly into SQL Server Mgmt Studio query, it works. But the same thing doesn't work in Access. INSERT INTO [GCTest05].[dbo].[tblBAIIDActivity] (... ,[ActivityTime] ... ) VALUES (...,'8:00:00 AM',...) The [ActivityTime] column is a time(0) data type.