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

    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
    cmd.Execute

     

    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.

    al.hughes@colliergroup.net

    Monday, November 22, 2010 9:04 PM

Answers

  • 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.


    Matt
    Monday, November 22, 2010 9:38 PM
    Moderator