Relationship After Upsizing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have recently upsized my access tables to a SQL server. The way I did it
was to put the tables in the SQL server and then linking the tables to
Access. I have noticed that all the relationships have disappeared after
upsizing. Is it neccessary to define the relationship again in Access? My IT
people told me that I do not need to define any relationship unless I am
doing a query... is that true? Would Access realize referential integrity
without enforcing it? Thank you in advance!
 
questionnaire said:
I have recently upsized my access tables to a SQL server. The way I
did it was to put the tables in the SQL server and then linking the
tables to Access. I have noticed that all the relationships have
disappeared after upsizing. Is it neccessary to define the
relationship again in Access? My IT people told me that I do not need
to define any relationship unless I am doing a query... is that true?
Would Access realize referential integrity without enforcing it?
Thank you in advance!
Click to expand...

If your tables on now on SQL Server it is SQL Server's job to enforce
referential integrity. Access has no choice in the matter. This assumes
that the relationships are properly set up on SQL Server. I don't know if
the upsize wizard does that automatically for you or not.
 
questionnaire said:
So I have to set up relationships for my tables in sql???????
Click to expand...

As I stated previously the upsize wizard "might" have done this for you. I
just don't know. You should be able to look at the objects on the server to
determine if that happened though.

If you think about it Referential Integrity has to be enforced by the
database engine (in this case SQL Server)because one can never assume that
the data will only be manipulated with only your one Access app. Any number
of different Access apps could link up to those same tables so the "rules"
have to be on the SQL Server or they would be useless.
 
Back
Top