i want to open a table from another database. the path to the other database is input by the user
i thought this would work:
DoCmd.RunSQL "SELECT * FROM " & tableName & " IN '" & dbPath & "'"
but it give me rt error 2342: a runsql action requires an argument consisting of a SQL statement. strange b/c if i create a new query and copy the sql into it, i can run it no problem