Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Upsize_ts field didn't appear all tables after upsize

Status
Not open for further replies.

lingyi

Programmer
Apr 11, 2001
65
SG
hi,
I am beginner of SQL server, recently, I had upsized my access database to SQL server as backend. I noticed that additional field 'upsize_ts' in some table. Why there aren't all the table being added this fields?, what is the purpose of this field? Can it be deleted or ignored? Please give me some explanation about this. Thanks..:)

 
The upsize wizard documentation says the following.

Timestamp Columns

By default, the Upsizing Wizard creates new columns with the data type of timestamp in SQL Server tables generated from Microsoft Access tables that contain floating-point (single or double), Memo, or OLE fields.

Terry
 
Dear Terry,
I using Access 97 and SQL 7.0
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top