Re: Form error????

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Correction:

I stated below that a TimeStamp was a GUID. That's not correct. In SQL
Server, a timestamp is guaranteed unique only within the database, whereas a
uniqueidentifier (data type) is meant to be unique in the world (i.e.,
globally unique, or GUID).

Kind of confusing now that (in SQL 2008) there is a new data type/alias
called ROWVERSION which replaces (or supplements) the existing timestamp
type. ROWVERSION makes it sound as though it is row (i.e., table) unique,
but it is still defined the same: unique to the database. The name change is
probably a good idea seeing how timestamp (data type) as defined by ANSI SQL
means "date and time", hence why many people think a SQL timestamp is a
date/time.

Thanks to a co-worker of mine who pointed this out to me.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

"Tom Wickerath" wrote:

Hi Jul

I think this is the KB article that describes the problem:

You may receive write conflict errors when you update records
of a linked SQL Server table (in Access 2000)
http://support.microsoft.com/kb/280730

Note: I added the parentheses around "in Access 2000", as this same issue
very likely applies to all versions of Access and SQL Server.

Adding a field to the SQL Server table of data type Timestamp is probably a
good thing to do. This is not a normal date/time value; it is a GUID
(Globally Unique Identifier) that SQL Server will generate without any action
needed on your part. However, if you are going to use a bit field in the
Access application, I would set a default value of zero. Many Access
developers refuse to use Yes/No fields for this very reason, among them
Access MVP Allen Browne.

Why I stopped using Yes/No fields
http://allenbrowne.com/NoYesNo.html

Access MVP Armen Stein has some good material available at his download
site, including the pros and cons of adding Timestamp fields:

http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp
---> See "The Best of Both Worlds: Access-SQL Server Optimization".


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
.

Relevant Pages