I am currently linking several SAGE tables into Access and have done this without a problem for a number of years.
SAGE have just done a complete system upgrade and 1 of the linked tables has developed a problem.
The SAGE table is dbo.StockItem
In my Access database when I use the standard method of New Data Source and choose either link through ODBC or SQL server, it allows me to create the link but some of the fields are not shown. They are not hidden.
When I look at the SAGE table using a SQL server program, I can see the table and ALL fields are visible
When I look at the linked table in access, some of the fields are not there.
I need 1 particular field from the table
CODE
When I look at the SQL table and look at the properties, there is nothing in the Datatype. It is blank.
There are several other fields where the Datatype is blank and none of these appear in the Access linked table.
I think this should actually read "varchar" and specify a string length because there are several other fields which are similar and show this datatype in their properties.
Has anyone ever seen anything like this and does anyone have a solution
SAGE have just done a complete system upgrade and 1 of the linked tables has developed a problem.
The SAGE table is dbo.StockItem
In my Access database when I use the standard method of New Data Source and choose either link through ODBC or SQL server, it allows me to create the link but some of the fields are not shown. They are not hidden.
When I look at the SAGE table using a SQL server program, I can see the table and ALL fields are visible
When I look at the linked table in access, some of the fields are not there.
I need 1 particular field from the table
CODE
When I look at the SQL table and look at the properties, there is nothing in the Datatype. It is blank.
There are several other fields where the Datatype is blank and none of these appear in the Access linked table.
I think this should actually read "varchar" and specify a string length because there are several other fields which are similar and show this datatype in their properties.
Has anyone ever seen anything like this and does anyone have a solution