Recent content by ahamied

Finally . According to data meanings concept , database engine took the wrong desision. Ahmed

Chris. So. There's no unique decision for the database engine Without. SQL server took the same decision. Paste error table should be created. So it's matter of data converting Which makes database engine stop thinking And didn't take the right decision . Thank u Chris for understanding the...

Stopher I attach 2 files Access and excel files copy all excel data from sheet 1 as it is then paste it to MainData table you'll be prompted that 11223 record was copied !!!! engine automatically ignore many values " text " and convert these values to null here is the problem the...

Stopher thank you for explanation what you said about teams and player, is true but..... what will the engine do when you try to insert a player belong to a team that is not included in your teams table ? should the engine accept and ignore the new team ID and convert to null ? or...

Not only access also SQ server return the same result. I love access , I gained too much money because of access. I don't have mistaken in my design. primary key must force integrity to foreign key. I'm going to apply the same tool on Ora, and MySQL and maybe I'll change the OS. or...

thank you Hi_Tech_Coach. -Null ... the UNKOWN -simply it's not a value , <> X/0 " X is a number" , it isn't an error ,and it's a logical fact. *Does Sam have a car? yes=1, No=0, or No answer given "Null may = silence " -because it's a logical fact, it's not accepted in Binary, Hex , or even...

thank you JHB according to Database normalization, what happen in my mdb file , mustn't happen can explain why that happened , and how ? may you download the original file again. I know how to correct it. but that should never occur in RDBMS can you upload a sample like my file ? how to add...

when we've two tables with 1 => many relation primary key in the master table won't be null. So, the foreign field in the the foreign table won't be null. But in my example : 1-primary table has no record. 2-foreign table has many records. 3-you can add records without has a primary value...