2950 error in Access 2013

[andrewcc1961]

I have a bit of a problem with a database in Access 2013. On 1 of the forms, I have a number of buttons which open other forms and filter the results using an embedded macro. All has been well until a few days ago when error 2950 pop up box started appearing. After fiddling around for a while it all works OK (without actually changing anything) until next time the database is opened. I checked to make sure the location is "trusted" and all seems OK. It would be much appreciated if someone could make a suggestion to rectify the problem.

 

[Trevor G]

Welcome to the Forum,

Read this article form Microsoft to see if it helps. http://support.microsoft.com/en-gb/kb/931407

 

[andrewcc1961]

Hello Trevor G. Thank you for your suggestion. I have read the post that you refer to which goes into "trusted" locations, unfortunately that doesn't seem to be the issue (although I could be wrong) for a couple of reasons - the location is trusted and it is only 1 form of about 20 (in the one data base) that has the issue.

 

[Trevor G]

Use the File Tab and Compact and Repair to see if that rectifies the issue. Next if that doesn't work what if you try and recreate the form and see if that will resolve the issue if so then just delete the form which is causing you problems.

 

[andrewcc1961]

Thanks so much for your input. All is working how it should today so have not had to do anything!!! I guess that is computers!!!!! Will see what happens over the next few days. Once again - Thanks.