Results 1 to 2 of 2

Thread: Constraints Go When Upgrading Access DB

  1. #1
    Steve Guest

    Constraints Go When Upgrading Access DB

    Hi,

    I have just tried to upgrade an Access database for the first time. All the tables & data have been moved into SQL Server, but all the Primary Keys & Foreign Keys have disappeared. The Primary Key columns are marked as allowing NULL values in SQL Server, and I can't change them to be NOT NULL.

    I used the ACCESS export facility to upgrade the database.

    Can anyone help me put the constraints into the SQL Server database???

    Thanks

    Steve

  2. #2
    Peter Christof-Dirry Guest

    Constraints Go When Upgrading Access DB (reply)

    Hi Steve,
    you have to use some product like MS Visual Interdev (included in MS Visual Studio 6.0), where you'll be able to edit the table definitions almost as easy as in Access (also for building Views visually like in Access).
    Otherwise there'll be a lot of scripting to build new tables, etc....

    Peter


    On 12/8/98 12:35:23 PM, Steve wrote:
    > Hi,

    I have just tried to upgrade an Access database for the first time.
    > All the tables & data have been moved into SQL Server, but all the Primary
    > Keys & Foreign Keys have disappeared. The Primary Key columns are marked as
    > allowing NULL values in SQL Server, and I can't change them to be NOT
    > NULL.

    I used the ACCESS export facility to upgrade the database.

    Can
    > anyone help me put the constraints into the SQL Server
    > database???

    Thanks

    Steve

Posting Permissions

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