(Anhgolden's Blog) - Khi Import Link Table từ MS SQL Server, khi muốn Delete hoặc Update Record trong Table Link, ta thường bị báo lỗi: Table Uneditable.
Phương án giải quyết: Table trong MS SQL Server (muốn Link đến Access) phải được đặt Primary Key.
Xem thêm: https://www.fmsinc.com/microsoftaccess/query/snytax/delete-query.html
Tuesday, March 29, 2016
Cannot Delete or Update Records from Table linked from MS SQL Server
Access,Sql
2016-03-29T13:41:00+07:00
Loading related posts...
TIN MỚI
- MS SQL: Config user to create or manage SQL Agent Jobs - 31-Aug-2023
- Warning: Null value is eliminated by an aggregate or other SET operation - 13-Jun-2023
- Sql Server: Lấy dòng dữ liệu ngẫu nhiên - 28-Apr-2022
- Sql: Insert Into Table2 Select * from Table1 - 18-May-2021
- Sql: Select * into New_table from Select - 18-May-2021
- SQL Server: Phân quyền cho User - 06-Sep-2017
- Functions: Excel vs MS Access vs SQL Server - 17-May-2017
- Access: The search key was not found in any record - 04-May-2016
CÁC TIN KHÁC
- Access: Tổng hợp các lỗi thường gặp - 13-Oct-2015
- Access Sql: Tổng hợp - 11-Nov-2014
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment