[AccessD] SQL Server times link as str

Hi John

What to do in such cases is to create a straight select query - an interface query - for this table only. Select all fields that come through all right; the remaining offending fields you convert or manipulate as needed. Your date field you could probably convert with CDate (or CVDate if zero length strings appear). Now use this query as source whenever your application have to pull data from the linked table.

Of course, if you need to write to the linked table you will need another query to interface in the other direction.

/gustav


On 23 Apr 2011 at 18:16, jwcolby wrote:

> The SQL Server fields are time(0) and DateTime.  It is picked up by
> Access as a string, IOW the field in design view of the linked table
> is a string. ..