MS-SQL AND ACCESS LINKED TABLE PROBLEM (#ERROR FIELDS) (cross)

S

Savas Ates

I have 3 tables with relations in MSSQL and try to link it to my access
database. But my fields returns with #ERROR .. I didnt find any solution ..
HEre is the my codes.








if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[TBL_PRODUCTS]') and OBJECTPROPERTY(id, N'IsUserTable') =
1)
drop table [dbo].[TBL_PRODUCTS]
GO

CREATE TABLE [dbo].[TBL_PRODUCTS] (
[PRODUCT_ID] [int] IDENTITY (1, 1) NOT NULL ,
[BRAND_ID] [int] NULL ,
[urunadi] [nvarchar] (255) COLLATE Turkish_CI_AS NULL ,
[bascudaurunkodu] [nvarchar] (255) COLLATE Turkish_CI_AS NULL ,
[ozellikleri] [ntext] COLLATE Turkish_CI_AS NULL ,
[cinsiyet] [nvarchar] (50) COLLATE Turkish_CI_AS NULL ,
[fiyat] [money] NULL ,
[pbirim] [nvarchar] (50) COLLATE Turkish_CI_AS NULL ,
[stok] [bit] NOT NULL ,
[ideefixeurunadi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[ShoppoAydinlarurunadi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[DeppoUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[WebdenAlUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[PazarAktifUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[EjoyaUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[WeblebiUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[HipernexUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[SiberStoreUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[AlGiyUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[BireBirUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[NevariaUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[XenShopUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[EreyonUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[DevSepetUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[bascudafiyat] [money] NULL ,
[ideefixefiyat] [money] NULL ,
[shoppoaydinlarfiyat] [money] NULL ,
[deppofiyat] [money] NULL ,
[WebdenAlFiyat] [money] NULL ,
[PazarAktifFiyat] [money] NULL ,
[EjoyaFiyat] [money] NULL ,
[WeblebiFiyat] [money] NULL ,
[HipernexFiyat] [money] NULL ,
[SiberStoreFiyat] [money] NULL ,
[AlGiyFiyat] [money] NULL ,
[BireBirFiyat] [money] NULL ,
[NevariaFiyat] [money] NULL ,
[XenShopFiyat] [money] NULL ,
[EreyonFiyat] [money] NULL ,
[DevSepetFiyat] [money] NULL ,
[BascudaSatis] [bit] NULL ,
[IdeefixeSatis] [bit] NULL ,
[ShoppoAydinlarSatis] [bit] NULL ,
[DeppoSatis] [bit] NULL ,
[WebdenAlSatis] [bit] NULL ,
[PazarAktifSatis] [bit] NULL ,
[EjoyaSatis] [bit] NULL ,
[WeblebiSatis] [bit] NULL ,
[HipernexSatis] [bit] NULL ,
[SiberStoreSatis] [bit] NULL ,
[AlgiySatis] [bit] NULL ,
[BireBirSatis] [bit] NULL ,
[NevariaSatis] [bit] NULL ,
[XenShopSatis] [bit] NULL ,
[EreyonSatis] [bit] NULL ,
[DevSepetSatis] [bit] NULL ,
[DENEME] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


/////////////////////////////////////////////////////////////
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[FK_TBL_BRANDS_TBL_GENDER]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE [dbo].[TBL_BRANDS] DROP CONSTRAINT FK_TBL_BRANDS_TBL_GENDER
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[TBL_GENDER]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TBL_GENDER]
GO

CREATE TABLE [dbo].[TBL_GENDER] (
[Gender_ID] [int] IDENTITY (1, 1) NOT NULL ,
[Gender_Name] [nvarchar] (50) COLLATE Turkish_CI_AS NULL
) ON [PRIMARY]
GO

/////////////////////////////////////////////////////////////

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[FK_TBL_PRODUCTS_TBL_BRANDS]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE [dbo].[TBL_PRODUCTS] DROP CONSTRAINT FK_TBL_PRODUCTS_TBL_BRANDS
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[TBL_BRANDS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TBL_BRANDS]
GO

CREATE TABLE [dbo].[TBL_BRANDS] (
[Brand_ID] [int] IDENTITY (1, 1) NOT NULL ,
[Brand_Name] [nvarchar] (255) COLLATE Turkish_CI_AS NULL ,
[Gender_ID] [int] NULL
) ON [PRIMARY]
GO
 
S

Sylvain Lafontaine

You forgot to declare a primary key for each of your tables; something that
Access won't like at all.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


Savas Ates said:
I have 3 tables with relations in MSSQL and try to link it to my access
database. But my fields returns with #ERROR .. I didnt find any solution ..
HEre is the my codes.








if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[TBL_PRODUCTS]') and OBJECTPROPERTY(id, N'IsUserTable')
= 1)
drop table [dbo].[TBL_PRODUCTS]
GO

CREATE TABLE [dbo].[TBL_PRODUCTS] (
[PRODUCT_ID] [int] IDENTITY (1, 1) NOT NULL ,
[BRAND_ID] [int] NULL ,
[urunadi] [nvarchar] (255) COLLATE Turkish_CI_AS NULL ,
[bascudaurunkodu] [nvarchar] (255) COLLATE Turkish_CI_AS NULL ,
[ozellikleri] [ntext] COLLATE Turkish_CI_AS NULL ,
[cinsiyet] [nvarchar] (50) COLLATE Turkish_CI_AS NULL ,
[fiyat] [money] NULL ,
[pbirim] [nvarchar] (50) COLLATE Turkish_CI_AS NULL ,
[stok] [bit] NOT NULL ,
[ideefixeurunadi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[ShoppoAydinlarurunadi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[DeppoUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[WebdenAlUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[PazarAktifUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[EjoyaUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[WeblebiUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[HipernexUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[SiberStoreUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[AlGiyUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[BireBirUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[NevariaUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[XenShopUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[EreyonUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[DevSepetUrunAdi] [char] (255) COLLATE Turkish_CI_AS NULL ,
[bascudafiyat] [money] NULL ,
[ideefixefiyat] [money] NULL ,
[shoppoaydinlarfiyat] [money] NULL ,
[deppofiyat] [money] NULL ,
[WebdenAlFiyat] [money] NULL ,
[PazarAktifFiyat] [money] NULL ,
[EjoyaFiyat] [money] NULL ,
[WeblebiFiyat] [money] NULL ,
[HipernexFiyat] [money] NULL ,
[SiberStoreFiyat] [money] NULL ,
[AlGiyFiyat] [money] NULL ,
[BireBirFiyat] [money] NULL ,
[NevariaFiyat] [money] NULL ,
[XenShopFiyat] [money] NULL ,
[EreyonFiyat] [money] NULL ,
[DevSepetFiyat] [money] NULL ,
[BascudaSatis] [bit] NULL ,
[IdeefixeSatis] [bit] NULL ,
[ShoppoAydinlarSatis] [bit] NULL ,
[DeppoSatis] [bit] NULL ,
[WebdenAlSatis] [bit] NULL ,
[PazarAktifSatis] [bit] NULL ,
[EjoyaSatis] [bit] NULL ,
[WeblebiSatis] [bit] NULL ,
[HipernexSatis] [bit] NULL ,
[SiberStoreSatis] [bit] NULL ,
[AlgiySatis] [bit] NULL ,
[BireBirSatis] [bit] NULL ,
[NevariaSatis] [bit] NULL ,
[XenShopSatis] [bit] NULL ,
[EreyonSatis] [bit] NULL ,
[DevSepetSatis] [bit] NULL ,
[DENEME] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


/////////////////////////////////////////////////////////////
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[FK_TBL_BRANDS_TBL_GENDER]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE [dbo].[TBL_BRANDS] DROP CONSTRAINT FK_TBL_BRANDS_TBL_GENDER
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[TBL_GENDER]') and OBJECTPROPERTY(id, N'IsUserTable') =
1)
drop table [dbo].[TBL_GENDER]
GO

CREATE TABLE [dbo].[TBL_GENDER] (
[Gender_ID] [int] IDENTITY (1, 1) NOT NULL ,
[Gender_Name] [nvarchar] (50) COLLATE Turkish_CI_AS NULL
) ON [PRIMARY]
GO

/////////////////////////////////////////////////////////////

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[FK_TBL_PRODUCTS_TBL_BRANDS]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE [dbo].[TBL_PRODUCTS] DROP CONSTRAINT
FK_TBL_PRODUCTS_TBL_BRANDS
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[TBL_BRANDS]') and OBJECTPROPERTY(id, N'IsUserTable') =
1)
drop table [dbo].[TBL_BRANDS]
GO

CREATE TABLE [dbo].[TBL_BRANDS] (
[Brand_ID] [int] IDENTITY (1, 1) NOT NULL ,
[Brand_Name] [nvarchar] (255) COLLATE Turkish_CI_AS NULL ,
[Gender_ID] [int] NULL
) ON [PRIMARY]
GO
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Not every data are treated equally 6
SQL Server SP equivalent 5
Updatable SQL 2000 partitioned view not updatable in Access 3
Stored Procedure Error Question 3
Calculating SUM if column = 1 2
Delay in executing SQL statement 8
Query not Updateable 1
Does Visio support sp_bindrule and sp_binddefault? 0

Top