Smiley1
05-17-02, 12:38
| 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 |