I have SQL server 2017 that I only have read access to the databases (thrid party owns it) I have been using MSaccess for years to build queries reports and with some help a small application that reads this data.
Recently we added some new functionality and now when I look at one of the new Linked tables I get #Deleted in every field
Note: this Table is critical because it provides the linkage between two databases I need.
Doing some research I found that this is probably caused because MSAccess Jet does not support bigint as a datatype and two of the fields are defined as bigint.
See article below.
The application provider, so far is un-willing, to create me a special view that does not have bigint as a data type and even if they do, I question if that would work since one of the fields that is defined as bigint is the one I need to link to the other database
- Does anyone have a way I can work around this issue using Access?
- Can anyone provide me a recommendation for another tool (I am not married to Access) that I can use to create queries, reports and exports that. I am pretty good at this stuff but not a developer so the easy drag and drop of Access and building queries and reports building is what I am looking for
Sorry this is so long but I thank any one in advance that can help and guide me