Hi, i have a table on the SQL server that i create with the next sentence:
CREATE TABLE [dbo].[INFOCARD Usadas] (
[ID] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
[PLANID] [numeric](10, 0) NULL ,
[FECHA USO] [datetime] NULL ,
[SERIAL] [char] (15) COLLATE Traditional_Spanish_CI_AS NULL ,
[SUBSCRIBERID] [char] (16) COLLATE Traditional_Spanish_CI_AS NULL ,
[Fecha Actualizacion] [datetime] NULL
) ON [PRIMARY]
GO
The problem is when the table is linked in MSAccess and i get no data, only error message with no description even when the table are populated with data. (more than 1.5M registers)
A temporary remedy that i found is create a view that returns all fields from the table [INFOCards Usadas]. In this way, linking the view on access works fine, but i wanna know what exactly i'm doing bad to solve the problem.
I dont think that problem is permissions, because i have more tables linked and works fine, the only problem is the table mentioned early.
P.S. Sorry about my english, my nature languaje is spanish.
The table name and fields are in spanish too.
CREATE TABLE [dbo].[INFOCARD Usadas] (
[ID] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
[PLANID] [numeric](10, 0) NULL ,
[FECHA USO] [datetime] NULL ,
[SERIAL] [char] (15) COLLATE Traditional_Spanish_CI_AS NULL ,
[SUBSCRIBERID] [char] (16) COLLATE Traditional_Spanish_CI_AS NULL ,
[Fecha Actualizacion] [datetime] NULL
) ON [PRIMARY]
GO
The problem is when the table is linked in MSAccess and i get no data, only error message with no description even when the table are populated with data. (more than 1.5M registers)
A temporary remedy that i found is create a view that returns all fields from the table [INFOCards Usadas]. In this way, linking the view on access works fine, but i wanna know what exactly i'm doing bad to solve the problem.
I dont think that problem is permissions, because i have more tables linked and works fine, the only problem is the table mentioned early.
P.S. Sorry about my english, my nature languaje is spanish.
The table name and fields are in spanish too.