Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Posts
    17

    Unanswered: External Tables problem

    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

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Are you using access for the backup and original ?

  3. #3
    Join Date
    May 2002
    Posts
    17
    Yes
    Access for both tables

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •