All geek questions in one place

Create a standalone application with Microsoft Access

As soon as I saw a database made in MS Access, which worked like a regular program, that is, with an executable file that opened a beautiful user interface and allowed access to forms and reports. I try to do the same, I even googled, but did not find how to do it. Does anyone know how to create such a stand-alone application with access?

+4
source share
3 answers

You cannot make an access database into an executable file. It just can't happen, however you can trick people into thinking that they don't use access in several ways, for example

  • Custom splash screen (just enter the bmp file in the folder and name it the same as your database)

  • Hide access window and toolbars

  • Change access icon

For example, look at this screenshot.

alt text

There are many things here, and it would be difficult to say that it was built using the old old access 97 (yes, I know that the standard toolbar gives it away, it will be at some point).

+5
source

I believe this tool is called the Microsoft Access Runtime Toolkit or something. The latest version is free, it is a departure from previous versions, which, I believe, you had to pay. From the previous version I fiddled with, it included a tool for creating an EXE file from an MDB or ACCB file, several icons for the EXE to use if you are missing it, and a program that helps you create Microsoft help files for your application.

This is a link to developer extensions. I believe that the 2007 version is as described above: http://www.microsoft.com/downloads/en/details.aspx?FamilyId=D96A8358-ECE4-4BEE-A844-F81856DCEB67&displaylang=en

Here is a link for the runtime environment that does not convert your Access database to an executable file, but allows you to run it on computers without installed access: http://www.microsoft.com/downloads/en/details.aspx?familyid=D9AE78D9-9DC6 -4B38-9FA6-2C745A175AED & displaylang = en

NOTE. Both are for Access 2007, the version I'm running. Your version may require something else - but it should be easy to find on the Microsoft website.

+4
source

If you want to trick the user into thinking that he is not using access, this will require some ingenuity. I have done it. You will need a way to make beautiful 2D images that you import for access, and then configure them as buttons and give them functionality. Make sure you put them on the splash screen. Not sure if you know VBA, but it will be necessary.

In the end, make sure that you are logged in to the setting and disable everything that may allow the user to somehow change the form. Then rename the file extension as follows: fileName.accdr

This is as close as possible to the regular program that you are going to get, and remember that it will look as good as the art you put into it.

0
source

Source: https://habr.com/ru/post/1332103/

More articles:


All Articles