I have imported two tables, USER_WORGROUPS and WORKGROUPS via ODBC connections. I have added an extra column to USER_WORKGROUPS called WORKGROUP_NAME which I would like to update whenever data is refreshed using the following UPDATE query:
UPDATE USER_WORKGROUPS.WORKGROUP_NAME
SET USER_WORKGROUPS.WORKGROUP_NAME = WORKGROUPS.WORKGROUP_ID
WHERE USER_WORKGROUPS.WORKGROUP_ID = WORKGROUPS.WORKGROUP_ID;
When I run this code, I get the "Could not find file..Groups.mdb" Error. As and additional detail, this is a brand new DB that I just built this morning and have saved to a local drive.