Results 1 to 3 of 3

Thread: Sql

  1. #1
    Join Date
    Nov 2002

    Unanswered: Sql

    I have an Access Database that was exported into SQL 2000 but SQL will not accept one of the fields which holds a future date (example: 01/01/03). Can you assist?

  2. #2
    Join Date
    Feb 2002
    What dates will it accept ? Do you have a check constraint ? What message to you get back when you attempt to insert this date ? What is the schema for the table ?

  3. #3
    Join Date
    Dec 2002

    DTS or Upsizing Wizard

    does you use DTS in Transfering data??
    i think this problem will not happen if u use upsizing wizard ... especially from office XP (access 2002) .. then relink tables on any Access 2000 machine.

    hope this help u.

Posting Permissions

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