Background
Total Access Analyzer is the world's leading Microsoft Access add-in product and designed to help you create better Microsoft Access solutions through comprehensive documentation and analysis. Total Access Analyzer offers more than 380 Reports, making it the most power documentation and analysis program for Microsoft Access professionals.
Question
Why doesn't Total Access Analyzer for Microsoft Access flag SQL reserved works (like "SELECT", "FROM", or "WHERE") when they are used in VBA code?
Answer
Total Access Analyzer doesn't flag VBA variable name conflicts with SQL Server reserved words, just VBA reserved words. It flags SQL Server reserved words that conflict with table/query names and field names. We do this because the conflict between the two groups doesn’t cause any impact in MS Access.
Comments
0 comments
Please sign in to leave a comment.