I have the following code,

MyDb.Execute _
("SELECT [Items Used On Jobs].* INTO Temp2 " _
& "From [Items Used On Jobs] left join [IU Backup] as IUB " _
& "on [Items Used On Jobs].[Audit Index] = IUB.[Audit Index] " _
& "where IUB.[Audit Index] is null")

if MyDb.RecordsAffected > 0 then
'Add new records to IU Backup
MyDb.Execute ("INSERT INTO [IU Backup] SELECT * FROM Temp2;")
endif

The question I have is how do I access the table "IU Backup" if it is in an external database.

Many thanks if you can help

Are you using access for the backup and original ?

Yes
Access for both tables

Thanks