Office Access Refactoring

Fabig, Richard 20 Reputation points
2024-04-09T14:07:03.8+00:00

Hey,

In our company we've a legacy software based on Office Access. We have access to the accdb-File with all sources. This software is connected to a SQL-Server Database.

We want to tidy up our database therefore we need to now which columns are used by Access (in Macros, in Reports in VBA-Code, etc.).

Therefore we need a posiblity to do a fulltextsearch overall Access-Objects which can contain the name of a column. Anyway, is there a tool which is able to to that work or which can dump all the definitions to textfiles so that we're able to do the fulltext search on ower own?

Regards

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
822 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,007 questions
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Fabig, Richard 20 Reputation points
    2024-04-10T10:47:02.2966667+00:00

    Dear Karl,

    thanks for your advice. I'll test that Add-In.

    Servus,

    Richard

    0 comments