[thelist] SQL server MS DB cannot form relationships help?

Ken Moore psm2713 at hotmail.com
Tue Jun 12 11:04:33 CDT 2007

Hi all,

I think that Ken Schaefer is correct that "Access is out of the picture at 
this stage".

I have used done almost everything with MS Access that can be done. If I 
were doing this, I simply move the data and then re-construct the 
relationships. Why? MS SQL has got many extras that Access does not 
involving data types, triggers, stored procedures, constraints, automated 
functions, etc.

Trying to know which ones translate to Access and exactly how they will work 
is a toss of the dice. This is especially true because some of the 
inconsistencies are data dependent.

The quickest way to learn is to get two or three really good books. If you 
have time and money for a tutor, that works even better. While application 
development is easy, much of the database design is less than intuitive in 

Ken Moore

>Did you say you were creating the FK constraint within Enterprise Manager,
>and both the tables are within SQL Server? Then I think that Access is out 
>the picture at this stage. There is some problem with creating the 
>within SQL Server itself.
>What is in your ALTER table statement? And what data do you have already 
>may violate the proposed constraint etc?
>-----Original Message-----
>From: thelist-bounces at lists.evolt.org
>[mailto:thelist-bounces at lists.evolt.org] On Behalf Of A Maynes
>Sent: Tuesday, 12 June 2007 5:51 PM
>To: thelist at lists.evolt.org
>Subject: Re: [thelist] SQL server MS DB cannot form relationships help?
> >> Could someone point me to a good resourse for
> >> creating relationships on tables that MS Access is using please?
> >
> >ms access?  or sql server?
>Microsoft Office Access and Microsoft MSSQL
>The Access DB is a MS Access project DB with the data coming in from the
>MSSQL DB I am simply having problems creating a relationship within the
>MSSQL that is then seen within the MS Access DB
>I'm just looking for recommended resources so I can read up on using
>MSSQL for MS Access project DB's as this is a shared application
> >
> >ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint?
> >
> >we'd need to see more than what you've posted, in order to help
> >
> >rudy

Picture this – share your photos and you could win big!  

More information about the thelist mailing list