Post reply

Disabling & enabling all of MS Access constraints

  • October 2, 2007 at 8:39 pm

    #69058

    Hi there, I am supporting a legacy app which uses MS Access 2003. My new application uses SQL 2005 Express and I would like to be able to bulk copy data into Access occasionally. Is there a command/script/way to disable and then enable constraints in MS Access just like in SQL (e.g. NOCHECK CONSTRAINT all & DISABLE TRIGGER ALL)

    Thanks in advance 😎

  • October 24, 2007 at 12:20 am

    #744784

    Hmm does anyone know of a way? Okie if I were to rephrase this way, how do we move large quantity of data from SQL 2005 Express to Access using Linked Tables. Does anyone know how to get around the constraints problem?

  • October 24, 2007 at 12:42 am

    #744786

    try database publishing wizard to extract and reload the data

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply