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! Anyone got an idea if this is normal of there's an option somewhere?
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 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 in linked table...
- Thread starter kalto
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Helpful tip
- Locked
- Question