Problem with Access database after KB4487017/KB4487026

We use an Access 97 database for our applications as a master database, so we can easily destribute this to customers. We access this master database using Adox to get the tables and columns (fields), compare it to the live SQL database and make changes where necessary.

Since the patch, we are getting errors when requesting the columns for wider tables. We are using an Adox.table and then use the .columns. When doing this for tables with more than 128 fields (exact number not sure) give error 3251 "Object or provider is not capable of performing requested operation".

This is causing all kinds of problems. 

Anyone know of a work around, or what is causing the problem now?

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

share your database and VBA codes maybe helpful to find the problem.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

Why not simply uninstall the update(s) since you've identified them as being the culprit(s)?
--
Daniel Pineault
Microsoft MVP 2010-2020

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

Uninstalling does resolve the issue.

However, we are not in control of the Windows updates on the system of a customer. We can't force an uninstall there.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

share your database and VBA codes maybe helpful to find the problem.

will work on a sample. 

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

If uninstalling the update(s) doesn't restore things then it is doubtful that the update(s) are the issue.

Did it ever work?  Have you made any recent changes?  Can you try an old version?  Does this happen on just one PC or all PCs?  Does your code compile?  Did you verify the reference libraries?  Have you compacted the db?  Have you decompiled the db?

--
Daniel Pineault
Microsoft MVP 2010-2020

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

Uninstalling does resolve the issue.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

If you're going to ask a question, you could at least read the answer.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

Thanks Bruce for that stunning and helpful comment.  Unlike you, I make mistakes.

You're so good, you solve the problem.

--
Daniel Pineault
Microsoft MVP 2010-2020

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

Sorry about that Nsch_L, I misread your previous post.

All i can say is that sadly, you're at the mercy of Microsoft.  Your client will have to accept this and uninstall the update.  I will advise the Access Dev team, but they'll need reproducible code to troubleshoot thing with.

--
Daniel Pineault
Microsoft MVP 2010-2020

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

Daniel, thank you for your response.

We will prepare the files as I mentioned earlier. It takes a little time as we have to make it usable for other parties.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

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 May 26, 2019 Views 298 Applies to: