VBA: Sudden "No value given for one or more required parameters" error in previously working code

[perguimo]

Hi, my first post so please bear with me. I'm not new to VBA but I have a problem for which I've been scratching my head for quite awhile. I have a long complex macro that reads data from several sources, mostly in a SQL server and in several SharePoint lists with ADO from different domains. This has been working for years now and just this week two of the SharePoint List connection give me the message "No value given for one or more required parameters.". I checked another two different SharePoint connections and they work fine. To troubleshoot the issue I modified the SQL statement to search where the errors might come from.

This SQL statement passes:

SELECT * FROM Prj_Tracking_Roles

but this one doesn't:

SELECT UserName FROM Prj_Tracking_Roles

The original SQL statement is a bit more complex but I think the two samples above gives the gist of the issue.

Some months ago I had a slight different issue and that was cause by a forced Microsoft patch on our company that created an error. A quick fix by Microsoft and another patch solved the issue. But I don't see on internet any reference to this on the last week. Have someone come across this issue and got a way to solve it?

Thanks

 

[jimrward]

Just in case UserName is a system reserved word try the following as a quick test
select Prj_Tracking_Roles.UserName from Prj_Tracking_Roles

 

[perguimo]

Hi Jimrward,

The field 'Username' was working before so I would not expect this to make any different. Nevertheless I have tried and it also fails. It works for other two connections (different SharePoint lists) within the same macro.

 

[perguimo]

Well, I finally managed to solve it. It was not a coding error but rather a change on the field name in the two SharePoint lists. I'm not sure if done by our SharePoint server administrators or forced by a patch update recently but the fields 'Prj_Code' in one list and 'UserName' on the other got mysteriously changed to 'Title'. As I am the owner of those two lists I would never have thought that someone/something else would change them.