Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Upsizing to SQL2005 (2007)

    Hi,

    I am trying to upsize to SQL2005 and having problems with the attached table in that it will not upsize the data. Cannot see why though?

    All the other tables within the DB have upsized from what I can see, just this one.

    Any ideas?

    The report says the table was skipped or export failed. But nothing else.
    Attached Files Attached Files
    Best Regards,

    Luke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Upsizing to SQL2005 (2007)

    I'm afraid only a small number of Loungers can open .accdb databases.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Upsizing to SQL2005 (2007)

    I have not looked at the attachment, but does the table include OlE Objects, Attachments or Multivalued fields?
    Regards
    John



  4. #4
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upsizing to SQL2005 (2007)

    Hi Luke,
    I've upsized your table into SQLExpress, both structure only and structure and data, and had no problems with either. I kept all the other default settings. Have you tried upsizing this table by itself? Maybe that will sprout an error message?
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

Posting Permissions

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