#DELETE viewing SQL Server table in Access

by

I have found the cause and solution. The affected tables had nvarchar fields as the primary keys. SQL Server Native Client has been deprecated for some time now and is replaced by MS OLE driver which is our mistake. The reason this problem has only reared its head now is due to an update to MS Access 365. I found this which has more details:

#DELETED when linked with ODBC

More Related Contents:

  1. Why is 1899-12-30 the zero date in Access / SQL Server instead of 12/31?
  2. How to programmatically create an ODBC Linked Table to a SQL Server View and have it be editable?
  3. Calling stored procedure using VBA
  4. SQL Server Passthrough query as basis for a DAO recordset in Access
  5. How to make a passthrough / passthru query editable?
  6. ODBC Call Failed with stored procedure – Pass through query
  7. nvarchar concatenation / index / nvarchar(max) inexplicable behavior
  8. How do I get list of all tables in a database using TSQL?
  9. Storing images in SQL Server?
  10. Escape a string in SQL Server so that it is safe to use in LIKE expression
  11. Limitations of SQL Server Express
  12. SQL time difference between two dates result in hh:mm:ss
  13. Storing files in SQL Server
  14. Dapper.NET and stored proc with multiple result sets
  15. “order by newid()” – how does it work?
  16. Import ‘xml’ into Sql Server
  17. T-SQL Dynamic SQL and Temp Tables
  18. Efficient ISNUMERIC() replacements on SQL Server?
  19. How to determine total number of open/active connections in ms sql server 2005
  20. Login to Microsoft SQL Server Error: 18456
  21. Find non-ASCII characters in varchar columns using SQL Server
  22. Violation of UNIQUE KEY constraint on INSERT WHERE COUNT(*) = 0 on SQL Server 2005
  23. How can I determine in SQL Server if a dateTime range overlaps another
  24. How to split a string after specific character in SQL Server and update this value to specific column
  25. How to create a yes/no boolean field in SQL server?
  26. Copy table to a different database on a different SQL Server
  27. Include missing months in Group By query
  28. Conditional JOIN Statement SQL Server
  29. How do you deal with blank spaces in column names in SQL Server?
  30. Oracle sequence but then in MS SQL Server

Leave a Comment