Access 2016 updating tables
Whatever the reason, tables, even ones with records in them, are easy to get rid of. When a table is deleted, all connections to it — including all relationships and references in queries and reports — are deleted, too.
A prompt appears when you choose to delete a table, reminding you of this. Here’s how it’s done: Now, you probably think it’s time to start entering records, but no, don’t start that just yet.
Linking to a SQL Server database from Access is not much different to creating a linked table to a backend Access database.
SQL Server is a more robust database management system than Access.
Certainly not in your first foray into database creation in Access 2016, and not even on your second or third attempt. Use Access’s simple interface to add the tables you want and delete the tables you don’t.
To name a table, you can do so when you first close it and are prompted to save it. This also gives you the opportunity to type a replacement name. Maybe you realize after building Table C that you really only need Tables A and B — or that Table D, which you’ve also created, really makes Table C unnecessary. Before you delete a table, check and recheck your database to make sure you aren’t deleting information that you need to keep.
However I now need to be able to create new records.
How can I create a new record using the form/subform that will update BOTH of these tables?
That seems like the logical use case for when credentials don't exist.
You can store data in a SQL Server database, then link to SQL Server from Access 2016 in order to run queries, reports, and even insert/update data.
Search for access 2016 updating tables:
I added a button to the current form to "add new record", but the I get an error "You cannot add or change a record because a related record is required in table".