Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    4

    Unanswered: Upsizing from Access and Default Values

    I'm using the upsizing wizard in Access 2000, but the default values in my Access tables don't seem to be transferring to my SQLServer tables. Everything else seems to be working fine, just not the default values...

    Please let me know if you've experienced a similar problem, or if you know of a solution to this issue.

    Thanks!

    -G

  2. #2
    Join Date
    Aug 2002
    Posts
    4

    Default value problem solved

    Oops, turns out it wasn't a bug, but a careless mistake on my part. I was using the export table function, rather than the upsizing wizard. If I use the upsizing wizard, and make sure to specify include defaults, then everything works as it should.

    I've attached a link to a screen shot showing the dialog with the include defaults option, just in case anyone else is as obtuse as me .

    Link to Screen Shot

    Thanks for the responses.

    -G

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •