Updating ms access database vb 2016
In turn, those design principles affect how you enter data.
As you proceed, remember that updating data is not the same process as entering new data.
If the record has a zip code that matches the lookup table, its City and State fields are replaced.
UPDATE tbl Address INNER JOIN tbl Zip Codes ON [tbl Address].[Zip Code] = [tbl Zip Codes].[Zip Code] SET [tbl Address].[City] = [tbl Zip Codes].[City], [tbl Address].[State] = [tbl Zip Codes].[State] WHERE ([Country] = 'US') Note: This doesn't work if you're in an ADP since those queries run on SQL Server which doesn't know VBA syntax.
FMS has worked with Microsoft Access since it debuted in 1992.
There have been many Access versions since then with multiple service packs, hot fixes and updates.