Asp.net Access 2003 Module RRS feed

  • Question

  • User-1931398643 posted


    I wrote an Access module and it work fine in Access. But I am trying to use a method in that module by my sql query and i cant get any result. Is there a way for accessing a method in an Access 2003 module programmatically?


    Thanks in advance...

    Monday, April 20, 2009 4:15 AM


  • User-1199946673 posted

    No! In an ASP.NET environment, when you're using an mdb file, your actually not dealing with an access database, but with a jet database. Only the tables and saved queries are accesible, you should do all the coding in the ASP.NET enviroment. Also, some build in access functions also don't work, among which the replace function! And when you're using Like statements, you should use '%' as the wildcard character, while in access, it is '*'

    How to configure Jet 4.0 to prevent unsafe functions from running in Access 2003

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, April 20, 2009 10:29 AM