I used the upsizing wizard in Access to convert a DB to SQL2000. The query in Access was,
SELECT [pLastName]+', '+[pFirstName] AS Name, [pMedicalRecord]
ORDER BY [pLastName], [pFirstName];
It has been converted to a user defined function in SQL,
CREATE FUNCTION vLastFirstNameLookUp ()
AS RETURN (SELECT TOP 100 PERCENT pLastName+', '+pFirstName AS Name, pMedicalRecord, pLastName, pFirstName
ORDER BY pLastName, pFirstName)
The front end is a VB
app that uses an Active-X User Connection to call the function in the SQL DB. Here is the error I receive when open is called,
Run-time error '-2147217900 (80040e14)':
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '`'.
The problem is that I don't see a ` anywhere. The Data Link Properties are set for OLE DB Providers for ODBC Providers.