General discussion

  • Creator
    Topic
  • #2297806

    Standalone Access Database

    Locked

    by chiiiba ·

    Is it possible 2 create a ‘shell’ around it (ie embedd it into anothr program) so it runs as a standalone programme (without having Access installed on the PC)…what development tools or software can I use. Or should I design a new application and if so what software would you recommend

    thnx

All Comments

  • Author
    Replies
    • #2670729

      Reply To: Standalone Access Database

      by melodia angelina ·

      In reply to Standalone Access Database

      With access you cannot create a exe file which runs as a standalone. However, you can do the following:

      1- Create the mdb database file
      2- From VB use the OpenDatabase method of the DAO workspace to connect to the mdb file specifying only the path.

      for example:

      Dim dbsTemp as Database

      set dbstemp = OpenDatabase(“db1.mdb”)

      provided that the db1.mdb is in the sample local directory of your application.

      I hope that is helpful.

    • #2672177

      Reply To: Standalone Access Database

      by erikdr ·

      In reply to Standalone Access Database

      What used to exist, but I’m not certain whether it’s still there in the latest MS Office versions, is the Access runtime. If you develop Access apps, you can build a runtime distrib including the app and give it FREE to customers of your app. What they get of course (after installing the runtime and mdb) is a set of exes which can only run, not design/change etc.

      HTH,

      – The Netherlands

    • #2671337

      Reply To: Standalone Access Database

      by d_gilmour_1978 ·

      In reply to Standalone Access Database

      I have seen this done before. What they did was changed the password to access the database and then hardcoded it into a front-end app (probably vb). This meant that the access source was hidden and you couldn’t access the data without the password. It wasn’t 100% fool proof but it worked rather well. I am not sure exactly how they set it up but that is the method they used.

Viewing 2 reply threads