mardi 3 février 2015

I've lost a scalar function in Access 2010 - how do I put it back? (I have the function in SQL)

I have a form in Access 2010 (.adp, not .accdb) that references a function titled dbo.search which seems to be missing. I am getting this error:


Cannot find either column "dbo" or the user-defined function or aggregate "dbo.search", or the name is ambiguous.


I cannot find the function "search" in the navigation pain, so I think I need to add it back. I have the function in a SQL 2005 database - what do I do?


Aucun commentaire:

Enregistrer un commentaire