("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;")
The question I have is how do I access the table "IU Backup" if it is in an external database.