ACCESS SQL Query to Create Relationship
Posted on 2004-08-23
I had two tables Customer & Source which are linked by SourceID. The Join was an OuterJoin. There was no referential integrity between them.
In the Source Table, SourceID datatype was Number. I would like it change to AutoNumber Without any problem to existing data.
I am using ADO to connect to MDB file.
I did this one using Query...
I removed the relationship between the Customer and Source.
Created a TempTable with Source Table Structure with AutoNumber.
Deleted the Source Table
Renamed the temp table to Source
Till this it is working fine. But when I try to bring back the relationship, it has a referntial integirty problem with Customer table and query fails. When relationship is added exixting data are checked and the query fails.
How can u create the relationship between tables with NO REFERENTIAL INTEGRITY and with OUTER JOIN as the default join type. How do i create a query for this .
I need all this one in a query, since this will be executed together with my aplication and all the client database will update their database.