I have read the following passage. It does not address VB accessing SQL
Server via RDO. I am not going through jet. I have yet to find anything
that tells me if timestamps are even usefull when accessing SQL Server this
Seen anything specific on RDO?
> You can obtain more precise information about why and when use a
> field under the Upsizing Tools Help file. You can download Upsizing Tools
> from Microsoft.
> Part of the help file follows:
> A timestamp field contains a unique value generated by SQL Server which
> updated whenever the record is updated. Microsoft Access uses the value
> timestamp fields to determine whether a record has been changed before
> updating it.
> A timestamp field provides the best performance and reliability. In the
> absence of a timestamp field, the Microsoft Access Jet database engine
> check all the fields in the record to determine if the record has
> which slows performance.
> Paulo Zeredo
> > I am developing an app in VB4 32 Bit and SQL Server 6.5 using RDO.
> > be using Timestamp columns in my tables? If so, in all tables or just
> > tables. If I do use timestamps, I presume its for performance purposes.
> > do I take advantage of them via RDO?
> > Thanks
> > --
> > Andrew Schmidt
> > Applied MicroSystems Corporation
> > (612) 975-0872