Develop Restore Macro

[benchambers]

G'day everyone,
I am learning how to use Access 2000 and having a bit of trouble. While I have four tables, one is Student_Details, one is Subject_Details and the other two is Student_Details(Backup) and Subject_Details(Backup).

I don't know how can I write the restore macro, which will delete the changed tables and replace them with the backup tables (ie restoring the changed tables(s) to their original data)

Can anyone give me any suggestions?

Thanks!

Ben

 

[ZanyJanie]

Ben,

You can create a function to delete your real table and then copy your backup table to the real table again.


DoCmd.DeleteObject acTable, "real table name"

DoCmd.CopyObject , "real table name", acTable, "backup table name"

 

[dark290790]

it says "you can't delete the table 'member';it is participating in one or more relationships"...how to restore it without deleting the relationship,,or to delete the relationship using codes or macros.??plzz help