question

garyhenry avatar image
garyhenry asked

Using MSAcces365 against SQL2017

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:

  1. Does anyone have a way I can work around this issue using Access?

  2. 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


thanks

Gary

accessmicrosoft-accesssql server 2017microsoft-access-database-engine
bint.jpg (27.2 KiB)
del.jpg (81.8 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.