Question : I am new in database and ms access.I am developing a database of income tax return form submitted […]
Tag: ms-access-2016
Table with two customer IDs that I want to relate to the entity
Question : Let’s say I have a transaction where Party1 and Party2 are associated, eg by a transaction – let’s […]
Linking tables in Access with unique ID
Question : I am creating a database in MS Access that has 3 different tables with 3 separate types of […]
MSAccess: creating a new row in a related table and linking it back to the “master” table
Question : In a hypothetical ‘cars’ database, assume there’s a model table and a make table: models modelID int model […]
Tables not showing up when linking SQL Server to Access using ODBC connection
Question : I am learning to link the back end of a database in SQL Server express 2016 to the […]
Trigger Access table on Insert
Question : I am using Access 2016 and building an in-house HR app for my team. I have a Position […]
Unable to update SQL Server via Access, Reserved error (-7776)
Question : I’m trying to use Access as a front-end for an SQL Server 2017 database. The objects I’m interested […]