home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 3 / Developers_Source_Vol_03_1996.iso / dbmsa / nov95 / spitf101.gif < prev    next >
Graphics Interchange Format  |  1996-02-21  |  83KB  |  436x334  |  8-bit (154 colors)
Labels: text | electronics | screenshot | display | software | number | web page | website | font
OCR: Performance Analyzer Analysis Results: W Telle 'SYDFLDS': Change dota type of feld'FLDNO' from 'Text' to'Long Integer" 7Table 'SYDFLDS': Change data type of feld'ADOTIME' trom Ted' to 'Dela/Time' SelectAll " Toble 'SYDFLDS'; Change dela type of feld 'LCKTIME' kom 'Text' to 'Deta/Tima' Recelect Al " Table 'SYORELN': Change dalo type of field 'LCKTIME" from 'Text' to 'Date/ Time" § Table 'SYDTABL"; Change dala type of feld 'LCKTIME' from 'Text' to 'Date/Time' Close Kay: ! Recommendation ? Suggestion Idea /Food Analysis Notes: Thia optimizeton will benest the Table 'SYDRELN' and potentiely other objects In your datoboso. Using appropriate dalo types can improve performance when you quary and access dale To assign appropriate data topes, open the toble in Design view and change the data type of the field lo the data type the wirerd suggests above. Caution :- Changing a dote type will arace existing dota that doesn't match the new deta type and will limit the kind of information you con store in the field. Help FIGURE 1 Access' Performance Analyzer provides useful tips for optimizing tables, queries, and forms.