[AccessD] Upsize errors

LOL, understood but... This is the upsize wizard.  Isn't it supposed to
figure that stuff out?

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Thursday, December 22, 2005 12:14 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Upsize errors

On 22 Dec 2005 at 0:09, John Colby wrote:

> The weird part is that when I did this on the BACK END directly I 
> didn't get these, but when I do it through the FE there are just tons of
them.
> 
> Server Error 547: ALTER TABLE statement conflicted with COLUMN FOREIGN 
> KEY constraint 'tblClaim_FK00'. The conflict occurred in database 
> 'DISCO_SQL', table 'tblClaimant', column 'CLMT_ID'.
> 

That one usually means that you are building a constraint before you have
poulated the parent table. In this case, it looks as though you do not have
all the data in tblClaimant before building tblClaim.



--
Stuart


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com