Tell me, are there libraries that allow you to work with Access through secure code?

Recently faced with the fact that jet has limited capabilities. Ie for example, you can not use many of the functions that I need (for example, Replace).

Maybe there are some ways to work through secure code? I do not want to work through COM ...

  • one
    Replace is a function that is implemented inside an office. Working with her through not com is unlikely to work. Jet allows you to perform sql queries. So I think either com or implement the necessary functionality within your application yourself - Bald

1 answer 1

I do not want to work through COM ...

In general, to work with Access under .NET, as a rule, ADO.NET is used, which is integrated into the platform itself and fully supports this DBMS. Therefore, there is no point in looking for additional libraries. Everything is already in the .NET itself.

  • When I try to execute a query that contains Replace, I get an error, something like "not known function Replace." Or am I doing something wrong? - iluxa1810
  • @ iluxa1810, Replace is a function from VBA (as already noted in an earlier comment) in the SQL specification that is used in Access, it is not included. Therefore, using it in the SQL query will fail. - Streletz