Microsoft OLE DB Provider for ODBC Drivers error '80040e14' RRS feed

  • Question

  • Hi,

    What am I missing???

    Dim dict
    Set dict = values
    Set cmd = Server.CreateObject ("ADODB.Command")
    cmd.ActiveConnection = dbConnection
    cmd.CommandText = "Ship_Update Delete"
    cmd.CommandType = 4


    Microsoft OLE DB Provider for ODBC Drivers error '80040e14'


    [Microsoft][ODBC Microsoft Access Driver] Undefined function 'CurrentUser' in expression.


    /al_hughes_colliergroup_net/Mahajan/include/Ship_Update_Table_events.asp, line 22

    Also where do I change my Email address in my Profile.


    New Email.


    Monday, November 22, 2010 9:04 PM


  • What this means is you have a stored procedure Ship_Update and inside this stored procedure there is a query that references the function CurrentUser.  For example something like:

    select * from table where user=CurrentUser()

    This function is not supported by the Microsoft Access driver.  Note that many VBA functions like CurrentUser() that work inside a Microsoft Access SQL statement do not work when you query the same Microsoft Access database using ODBC, this is a limitation of the ODBC driver.

    Monday, November 22, 2010 9:38 PM