[AccessD] SQL Server times link as str

Stuart McLachlan stuart at lexacorp.com.pg
Sat Apr 23 16:28:18 CDT 2011


What sort of issues? 

Is the SQL Server field a datetime or a smalldatetime?
Using ODBC?  What Client?

AFAIK, Access doesn't have a "Date" field type, only  a Date/Time

-- 
Stuart
 

On 23 Apr 2011 at 12:06, jwcolby wrote:

> I am linking to tables with date / time fields in SQL Server.  The
> field in Access says it is a date.  This appears to be causing all
> kinds of issues.  I cannot see any way to intercept the link and tell
> the wizard that a specific field is a specific data type.  Is there
> any way to fix this?
> 
> -- 
> John W. Colby
> www.ColbyConsulting.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 






More information about the AccessD mailing list