Delete and Replace Table

[EddyLLC]

Hi All, I want to delete a table in a back-end database and then move a table from a second database into the first to replace the one deleted. It's basically a simple swap. When a form opens up in the front-end database the code will delete the back-end table and move its replacement from the front-end to the back-end.

Is this possible? if so any thought on getting started is greatly appreciated.

Thanks

 

[MajP]

DoCmd.DeleteObject acTable, "Former Employees Table"

DoCmd.TransferDatabase acImport, "Microsoft Access", "pathandFileName, acTable, "sourcetblName", "destinationtblName", False

Look in the help file for these two methods. Examples shown.

 

[TheAceMan1]

How are ya EddyLLC . . .

Note: If the table is a parent the child tables need to be deleted first!

[blue]DBEngine(0)(0).Execute ("DROP TABLE [purple][b][i]tablename[/i][/b][/purple];")[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]