Dear all, I am using MS Access 2010 to view and filter data from SQL Server. It is very handy to quickly find and filter SCCM data. (of course in a read only mode) Now there is a problem when querying data from ConfigMgr 2012, it returns #Deleted for each field: "#Deleted" errors with linked ODBC tables<http://support.microsoft.com/kb/128809>
There are some solutions around but nothing I like. One would be to create SQL pass-through queries, another is to create additional sql views with convert function. Maybe anybody already discovered the same problem and has a solution handy. Or maybe there is a free tool similar to MS Access which covers my request. Thanks for comments, Reto -- This e-mail message and any attachments are of a confidential nature. The information is intended for the named addressee exclusively. If you are not the addressee, you may not electronically disseminate, otherwise distribute or copy this e-mail message, and you may also not use it for any purpose. Please notify the sender immediately if you have received this e-mail message by mistake, and delete this e-mail message and its attachments. E-mail transmissions could be lost, intercepted, corrupted or destroyed. They could arrive late or incomplete, or could even contain viruses. Confidentiality and reliability of the information so transmitted cannot be guaranteed. Rothschild Bank therefore does not accept any liability or responsibility for errors or omissions regarding the information transmitted through e-mail. If verification of the information transmitted through e-mail is required, please ask for postal delivery by contacting Rothschild Bank.. This e-mail message is provided for information purposes only. It should not be construed as an offer or solicitation to buy or sell any financial instruments or services. It is not to be made available to US persons and is not to be circulated within the USA.
