two ideas... 'turn off' constraints during update, or change access autonumber to integer for import and then back again.
Use a cold fusion script instead of DTS Elliot "Steve Onnis" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > > Has anyone exported SQL DBs to Access? > > I having trouble getting the DTS to set up the primary keys and foreign key > constraints on export, and cause of this I can't reset the columns to be > Auto Number. > > Any ideas? > > Regards > > Steve Onnis > Domain Concept Designs > +61 422 337 685 > +61 3 9444 7504 > > http://www.domainconceptdesigns.com <http://www.domainconceptdesigns.com> > > ("If you think it can't be done, you haven't asked me!") - Steve Onnis > > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
