I am starting a new post per the advice of another user as I posted on an 8-year-old post without a resolution to my issue. So here it is.
I am in the process of transitioning my Access Backend database to an MS SQL database and I am having a couple of issues. My primary issue is stated below.
My control source for the form is a query created from a single linked table from the Access Backend. All functionality works i.e. displays all records and allows the users to delete and add new records. When I change the control source query to use the new MS SQL Backend table the form is blank and no form controls are displayed and the user no longer can scroll through the records, update, delete or add.
The form displays the data based on a default date range set in the form which is set for the current day. This causes no results in the query then causing the form to be blank, when I change the default date range to a range that contains data the form opens correctly with the form controls and all functionality EXCEPT entering a new record.
Any help getting to a solution will be greatly appreciated.
I have a quick video of my screen showing how it works when using the linked Access table vs MS SQL table but I am not sure how to post that.
**Edit**
One other note to point out. When I switch my source table from the linked access to the linked SQL table the "New (blank) Record" selector is disabled whereas when I use the linked access table the "New (blank) Record" selector is enabled.
I have checked all the permissions to the table and are below.
TABLE_QUALIFIER TABLE_OWNER TABLE_NAME GRANTOR GRANTEE PRIVILEGE IS_GRANTABLE
SouthForkActivityTracking dbo tblAccomplishment dbo dbo DELETE YES
SouthForkActivityTracking dbo tblAccomplishment dbo dbo INSERT YES
SouthForkActivityTracking dbo tblAccomplishment dbo dbo REFERENCES YES
SouthForkActivityTracking dbo tblAccomplishment dbo dbo SELECT YES
SouthForkActivityTracking dbo tblAccomplishment dbo dbo UPDATE YES
I am in the process of transitioning my Access Backend database to an MS SQL database and I am having a couple of issues. My primary issue is stated below.
My control source for the form is a query created from a single linked table from the Access Backend. All functionality works i.e. displays all records and allows the users to delete and add new records. When I change the control source query to use the new MS SQL Backend table the form is blank and no form controls are displayed and the user no longer can scroll through the records, update, delete or add.
The form displays the data based on a default date range set in the form which is set for the current day. This causes no results in the query then causing the form to be blank, when I change the default date range to a range that contains data the form opens correctly with the form controls and all functionality EXCEPT entering a new record.
Any help getting to a solution will be greatly appreciated.
I have a quick video of my screen showing how it works when using the linked Access table vs MS SQL table but I am not sure how to post that.
**Edit**
One other note to point out. When I switch my source table from the linked access to the linked SQL table the "New (blank) Record" selector is disabled whereas when I use the linked access table the "New (blank) Record" selector is enabled.
I have checked all the permissions to the table and are below.
TABLE_QUALIFIER TABLE_OWNER TABLE_NAME GRANTOR GRANTEE PRIVILEGE IS_GRANTABLE
SouthForkActivityTracking dbo tblAccomplishment dbo dbo DELETE YES
SouthForkActivityTracking dbo tblAccomplishment dbo dbo INSERT YES
SouthForkActivityTracking dbo tblAccomplishment dbo dbo REFERENCES YES
SouthForkActivityTracking dbo tblAccomplishment dbo dbo SELECT YES
SouthForkActivityTracking dbo tblAccomplishment dbo dbo UPDATE YES
Last edited: