In access create a module such as:
Public Function getCurrentDayHour() As String
Dim strQuery As String, rsResult As ADODB.Recordset
strQuery = "dbo.spCurrentDateTime"
Set rsResult = CurrentProject.Connection.Execute(strQuery)
getCurrentDayHour = Mid(rsResult("CurrentDateTime"), 3)
End Function
In SQL Server, create a store procudure with:
Create procedure dbo.spCurrentDateTime
as
select GETDATE() as CurrentDateTime
It Works!!!