hello all.
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
Two questions:
Sorry this is so long but I thank any one in advance that can help and guide me
thanks
Gary