Hi Everyone,

I am trying to add VBA code behind my form that will let me access 2 different Access databases. The first database is called Original_Test (this has a table called tblMASTER) and the second is called Copy_Test(this has a table called tblUSER).

I have the below code:

SQL1 = "INSERT INTO tblUSER select user_id,dept, group from Original_Test.tblMASTER where user_id = '" & txtUserID & "'"
db1.Execute SQL1

When I run this, I get an error saying that the tblMASTER is not found in the database. Can anyone help me resolve this?

Thanks in advance for you help:)

can you post more of your code... like where you declare your DB's?

"Life is a Database"

Sure...Below is my code:

Private Sub Command0_Click()

    Dim db As Database
    Dim db1 As Database
    Dim wrkJet As Workspace
    Dim SQL As String
    Dim SQL1 As String


    Set wrkJet = CreateWorkspace("NewJetWorkspace", _
          "admin", "", dbUseJet)
    Set db = wrkJet.OpenDatabase("C:\Documents and Settings\Original_Test.mdb")

    Set db1 = wrkJet.OpenDatabase("C:\Documents and Settings\Copy_Test.mdb")


    SQL1 = "INSERT INTO tblUser select user,dept, group from tblMaster where user = '" & txtUserID & "'"
    db1.Execute SQL1

End Sub



Thanks!!

are you sure you're not mixing up which database/table has which fields? I tried your code and it works. Also, make sure you have DAO library loaded in your References.

"Life is a Database"