Migrate Data between Access DB's

[ymk]

I have the Production and QA Access Databases and I am trying to see what's the best way to migrate data between Prod to QA.

Tried with Import and export but few tables have relationships on them and they can't be deleted.

Is there a better way to acheive this?

Thanks,
YMK

[ymk]

Can someone please throw some input on how can I port data between two Access DB's?

Thanks.

[MMcCarthy]

I have the Production and QA Access Databases and I am trying to see what's the best way to migrate data between Prod to QA.

Tried with Import and export but few tables have relationships on them and they can't be deleted.

Is there a better way to acheive this?

Thanks,
YMK

Try using

 DoCmd.TransferDatabase acImport, ....................