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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Default value?

Status
Not open for further replies.
kalto

kalto

Programmer
Apr 1, 2004
14
0
0
CA
Hi, i'm having a trouble with my linked table... Everything seems ok, except the fact that Access doesn't seem to see the default value defined in SQL Server. Like, i create a table in the SQL Server Enterprise manager, one of the field having 0 as default value, i link that table to my mdb, and when i look at the table design from Access, there's no default value! If i add a record and i don't enter anything for that field, it just leave it as a NULL...

Anyone got an idea if this is normal of if there's an option somewhere?
 
Status
Not open for further replies.

Similar threads

MrMode
  • Locked
  • Question
Table locked after inserting a record with autonumber field value
Replies
2
Views
45
MrMode
MrMode
mtownbound
  • Locked
  • Question
Value-Based Incrementing 1
Replies
10
Views
64
mtownbound
mtownbound
Moss100
  • Locked
  • Question
Which value do I store in the primary table from a support or lookup table? 4
Replies
15
Views
137
MajP
MajP
hefly
  • Locked
  • Question
Changing Default value of Memo field
Replies
8
Views
43
dhookom
dhookom
lamarw
  • Locked
  • Question
Multi value table field, a real problem for duplicating 1
Replies
12
Views
97
Darrylles
Darrylles

Part and Inventory Search

Sponsor

Back
Top