[AccessD] Seconds Missing

Gustav Brock gustav at cactus.dk
Mon Jul 19 09:43:53 CDT 2004


Hi Steve and Martin

That could be it. SmallDateTime doesn't store seconds - maybe the
connection "remembers" the field as such even though you have changed
it later to DateTime.

/gustav


> You may need to delete the linked table from Access and then re-link it.
> I recently had an Access linked table refuse to see a decimal field on
> SQL Server as anything but an integer until I delete/relinked.  (I
> refreshed the links endless times to no avail).  I think our friend
> Access sometimes just won't pick up all the schema info unless you force
> it on him!




More information about the AccessD mailing list