Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL2000 Table Linked into MSAccess 97 problem!

Status
Not open for further replies.

Edimator

IS-IT--Management
Mar 13, 2001
49
VE
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top