Therefore, the inability to easily change the size of a primary key field is not because of poor database design, it is because the dbms and sql tools to handle the database are grossly inadequate, clearly designed by programmers with a theoretical rather than an actual understanding of the real world.. Before setting or changing the primary key in a microsoft access database, it's important to understand that microsoft access is going to automatically create a primary key when a table is being. Modify or change the data type setting for a field. and in some cases may remove the data entirely. for information about how access changes data when you change a data type, see the section restrictions on changing data not allowed if the autonumber field serves as a primary key. memo. not allowed if the autonumber field serves as.
Use a number for the primary key whenever possible. sql server or other database management systems process number data types faster than character data types. keep it simple. don't use any special characters, embedded spaces, or a mix of upper and lower capitalization. never change the primary key after you assign it.. Learn about assigning a primary key to a table in microsoft access at www.teachucomp.com. get the complete tutorial free at http://www.teachucomp.com/free -. Performance is totally irrelevent to the data type of the primary key, it is like asking will the truck be faster than the sports car? if i have to move a ton of rocks then the answer is yes. if i have to move a ton of rocks i should use a truck regardless. a primary key is dictated by the business model..
Subscribe by Email
Follow Updates Articles from This Blog via Email
No Comments