Ask a new question

SOLVED: UniqueTable property broken in Access 2013. Hot fix 2863871 will not work for Access 2016.

We are using ADODB to "talk" to SQL Server from MS Access.  Everything works ok using Access 2010, but we are upgrading to Access 2016.  When I tried the database using 2016, I receive an error message that the "UniqueTable" property is not recognized.

I searched the web and found this is a KNOWN ISSUE and there is a hot fix (KB2863871) for Access 2013.  But the hot fix will not run since I don't have Access 2013.  And there doesn't appear to be a hot fix for 2016.

Other than rewriting the database to only update a single table at a time (no joined tables allowed), what can I do?

If I take out the UniqueTable setting, then the ADODB recordset becomes non updateable.

Update 2017/02/13:

This issue appears to have been resolved by Microsoft with patch 3115503.

https://support.microsoft.com/en-us/help/3115503/december-6,-2016,-update-for-access-2016-kb3115503

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

How do I use DAO to get/save data in SQL Server?

We can't use ODBC linked tables.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

You would use a passthrough query to get or save data.
-Tom.
Microsoft Access MVP
Phoenix, AZ

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

But doesn't a passthrough query require using ODBC?  The point of using ADO was to avoid using ODBC.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

You said: We can't use ODBC linked tables.

My solution does not.

Now you're saying you want to avoid ODBC altogether. I have no further advice other than to suggest to reconsider that. Most of the rest of the Access world runs on ODBC. It's still being maintained (note the Native Client drivers) and not going anywhere.

-Tom.
Microsoft Access MVP
Phoenix, AZ

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

This issue appears to have been resolved by Microsoft with patch 3115503.

https://support.microsoft.com/en-us/help/3115503/december-6,-2016,-update-for-access-2016-kb3115503

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Jim,

Well that's a surprise! Hope it works!

Have you given the update a try? 

Thanks

Gerry

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I did and it appears to solve the problem.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Well that's good to know.

I went looking to see if there was an update recently without any luck.

Thank you for putting the info on here. 

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

 
 

Question Info

Last updated September 30, 2021 Views 1,285 Applies to: