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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conversion from Access questions

Status
Not open for further replies.
mkov

mkov

Programmer
Sep 10, 2003
203
US
I am new to SQL Server and have a question about converting an Access back-end database to SQL Server.

How can I setup a field as yes/no like in Access?

Does anyone have any other advice or warnings that I need to know while I am doing this?

Thanks for your help.

 
Sort by date Sort by votes
YOu can use a bit field. Note that the value of -1 in Access is the value 1 in a bit field.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bharons
  • Locked
  • Question
Pick up value from combobox
Replies
0
Views
581
bharons
bharons
Auguy
  • Locked
  • Question
Move SQL DB to the Cloud and Access it From a .Net Program
Replies
0
Views
189
Auguy
Auguy
grnzbra
  • Locked
  • Question
GOING FROM DD/MM/YYYY TO MM/DD/YYYY 1
Replies
4
Views
905
JeffModen
JeffModen
Auguy
  • Locked
  • Question
Move From SQL 2014 Express To Newer Version
Replies
2
Views
281
Auguy
Auguy
eboughey1008
  • Locked
  • Question
Import columns from one table into another table with dissimilar field layout
Replies
7
Views
408
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top