Hello, there is a small company that has its own database in MS Access, the database grows larger and, accordingly, begins to hang and has many problems, threw work, move this database somewhere that would be more productive and add more functionality (for example, reports were generated and sent to the mail automatically at a certain time), I ask the experienced experts how to do better and where to move the entire database and program it, what programs and licenses will be needed? I assume that on MS SQL Server.

    1 answer 1

    Correctly assume. In Access, there is an option to transfer tables to MSSQL, while forms, queries and reports will remain in Access. This will get the following:

    1. The interface for users does not change;
    2. Tables are hosted on a faster server;
    3. To make changes (forms, requests and reports) it is enough to fix the client part and send it to users;
    4. MSSQL will carry out a full backup of your data on the schedule made

    About automatic report generation: I see no point. Climbing into the database, launching a report and saving PCM to pdf / xlsx / cvs is very elementary ... Although in Access + Outlook there is a function "data collection ...". I did not use it myself, but look - maybe this is what you need .... Ps Now I read about this function. It sends a specially created form for collecting data from users. But! You can program a button on the form to generate a report and send to the e-mail address.