Lỗi mở file word lỗi following sql command năm 2024
Xin chào anh chị GPE, em có viết một đoạn code để mở 1 file word có chứ Mail Merge, nhưng khi chạy code nó không có hỏi update dữ liệu như khi dùng chuột mở bình thường, anh chị xem em viết sai ở đâu ạ Khi em ở thủ công thì nó báo thông báo này, mình bấm Yes thì nó cập nhật dữ liệu mới trong File Excel View attachment 276429 Em phải sửa như thế nào, để nó không hỏi mà tự update luôn ạ, Em cám ơn anh chị ạ! Cái này hình như phải thiết lập SQLSecurityCheck, lúc trước tôi có gặp mà quên rồi, nó ngăn chặn các virus chạy các câu lệnh SQL. Bạn kiếm từ khóa đó xem thử.
Cám ơn a, E đã tìm, nhưng ko ra ạ.
Chủ thớt thử tham khảo bài viết này xem, trên trang web của Microsoft. Lần chỉnh sửa cuối: 25/5/22
Bạn thử code sau. Biết đâu lại may mắn. "Nó" có hỏi hay không không quan trọng. Vấn đề là sau đó bạn không phải chọn nguồn dữ liệu thì có thể trộn thư luôn được không. Cách test: trước hết mở tập tin Excel -> chỉnh sửa dữ liệu -> lưu lại -> đóng tập tin Excel -> chạy code bên dưới -> không chọn lại Repcipients -> Finish & Merge - > Kiểm ra xem kết quả có chứa cac chỉnh sửa hay không. Đánh dấu đã đọc When you open a mail merge main document in Microsoft Office Word, you experience one of the following symptoms:
Note It could be that you are using a program, for example Microsoft Access or Microsoft Visual FoxPro, to programmatically open a mail merge main document file when you experience the symptoms in this article. CauseThe prompt that is described in the "Symptoms" section is by design. This prompt exists in all later versions of Microsoft Office and was introduced in Office XP Service Pack 3. This prompt was added in the products listed in the "Applies to" section to make mail merge more secure. If you click Yes when you receive the prompt, you let code run on your computer. A malicious user may be able to craft a SQL query that is designed to steal or to destroy data that you have access to. If you click No when you receive the prompt, you do not let code to run. Note Setting DisplayAlerts=none through VBA suppresses the prompt when the file is opened by using VBA, but uses the NO option to open the document and no data is attached to the mail merge main document. WorkaroundWarning This workaround may make your computer or your network more vulnerable to attack by malicious users or by malicious software such as viruses. We do not recommend this workaround but are providing this information so that you can implement this workaround at your own discretion. Use this workaround at your own risk. Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base: 322756 How to back up and restore the registry in Windows If you read and understand the disclaimers that are provided in this article and if the documents that you open by using mail merge are from a trusted source, you may want to work around the behavior that is described in the “Symptoms” section. To work around this behavior, disable the security prompt by using the SQLSecurityCheck registry key. To disable the security prompt by using the SQLSecurityCheck registry key, follow the appropriate steps for your version of Microsoft Word. Word 2013HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Word\Options "SQLSecurityCheck"=dword:00000000
Word 2010HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Word\Options "SQLSecurityCheck"=dword:00000000
Word 2007HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Word\Options "SQLSecurityCheck"=dword:00000000
Word 2003HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Word\Options "SQLSecurityCheck"=dword:00000000
Word 2002 Service Pack 3HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Word\Options "SQLSecurityCheck"=dword:00000000 To do this, follow these steps:
StatusThis behavior is by design. Bạn cần thêm trợ giúp?Bạn muốn xem các tùy chọn khác?Explore subscription benefits, browse training courses, learn how to secure your device, and more. Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge. |