Upsize trouble

  • Thread starter Thread starter Mike Long
  • Start date Start date
M

Mike Long

I am upsizing an Access db to SQL. I have these tables: Products, Brands,
Colors, a Junction table between Products and Colors, and a Junction table
between Brands and Colors. They link in a circle. The idea is to be able to
pick a brand from a drop list and have only the appropriate colors for that
brand display when entering products.Everything seems to work in the linked
mdb file, but I got these messages during the upsize.


[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE statement
conflicted with COLUMN FOREIGN KEY constraint 'tblJctBrandsColors_FK01'. The
conflict occurred in database 'DoughboysBE', table 'tblColors', column
'strColorID'.
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE statement
conflicted with COLUMN FOREIGN KEY constraint 'tblJctProductsColors_FK00'.
The conflict occurred in database 'DoughboysBE', table 'tblColors', column
'strColorID'

Can anyone give me a clue as to what these messages are trying to tell me? I
know FK is foreign key, but what is 00 and 01? The data types are the same
and the field sizes are identical on all sides.

I tried making an adp, but nothing worked, and my client is the only person
doing input, so there is no need for multiple connections. These products
will eventually be on a web based ordering system.
 
The errors seem to indicate that there are 2 FKs on
tblColors.strColorID. I'd remove both FKs in Access, update the db,
then create the correct FK in the SQL db.
 
Yes there certainly are 2 foreign keys. Is that a no-no in SQL server? How
else do you relate one parent table to 2 child tables?

Thank you

MGFoster said:
The errors seem to indicate that there are 2 FKs on
tblColors.strColorID. I'd remove both FKs in Access, update the db,
then create the correct FK in the SQL db.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)


Mike said:
I am upsizing an Access db to SQL. I have these tables: Products, Brands,
Colors, a Junction table between Products and Colors, and a Junction table
between Brands and Colors. They link in a circle. The idea is to be able to
pick a brand from a drop list and have only the appropriate colors for that
brand display when entering products.Everything seems to work in the linked
mdb file, but I got these messages during the upsize.


[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE statement
conflicted with COLUMN FOREIGN KEY constraint 'tblJctBrandsColors_FK01'. The
conflict occurred in database 'DoughboysBE', table 'tblColors', column
'strColorID'.
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE statement
conflicted with COLUMN FOREIGN KEY constraint 'tblJctProductsColors_FK00'.
The conflict occurred in database 'DoughboysBE', table 'tblColors', column
'strColorID'

Can anyone give me a clue as to what these messages are trying to tell me? I
know FK is foreign key, but what is 00 and 01? The data types are the same
and the field sizes are identical on all sides.

I tried making an adp, but nothing worked, and my client is the only person
doing input, so there is no need for multiple connections. These products
will eventually be on a web based ordering system.
Click to expand...
Click to expand...
 
The problem is on the upsizing wizard side, not on the SQL-Server.

S. L.

Mike Long said:
Yes there certainly are 2 foreign keys. Is that a no-no in SQL server? How
else do you relate one parent table to 2 child tables?

Thank you

MGFoster said:
The errors seem to indicate that there are 2 FKs on
tblColors.strColorID. I'd remove both FKs in Access, update the db,
then create the correct FK in the SQL db.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)


Mike said:
I am upsizing an Access db to SQL. I have these tables: Products, Brands,
Colors, a Junction table between Products and Colors, and a Junction table
between Brands and Colors. They link in a circle. The idea is to be
able to
pick a brand from a drop list and have only the appropriate colors for that
brand display when entering products.Everything seems to work in the linked
mdb file, but I got these messages during the upsize.


[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE statement
conflicted with COLUMN FOREIGN KEY constraint
'tblJctBrandsColors_FK01'. The
conflict occurred in database 'DoughboysBE', table 'tblColors', column
'strColorID'.
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE statement
conflicted with COLUMN FOREIGN KEY constraint 'tblJctProductsColors_FK00'.
The conflict occurred in database 'DoughboysBE', table 'tblColors', column
'strColorID'

Can anyone give me a clue as to what these messages are trying to tell me? I
know FK is foreign key, but what is 00 and 01? The data types are the same
and the field sizes are identical on all sides.

I tried making an adp, but nothing worked, and my client is the only person
doing input, so there is no need for multiple connections. These products
will eventually be on a web based ordering system.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top