Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Can users without Access open the FrontEnd?

Discussion in 'Information Technology' started by Adam Lei, Jul 28, 2006.

  1. Adam Lei

    Adam Lei
    Expand Collapse
    Guest

    I built an Access database for about 50 users in my department. Database went
    through 3rd normalization. I splitted the DB into Front End / Back End; so
    far things seem to be OK.

    However, a few other employees of the company (not in my department but have
    access to the share drive) would also like to access the database. The
    problem is that they do not have licences of Access. Can they access the
    database by using the Front End? If not, can they access the database if I
    save all forms and reports in "Data Access Page" format?

    Also, if there are no quick fixes, can you give me some links to related
    articles?

    Thanks,
    Adam
     
  2. Loading...


  3. Jen

    Jen
    Expand Collapse
    Guest

    They can run your frontend using a runtime version of Access. Just create an
    install that includes the runtime version. j.

    "Adam Lei" wrote:

    > I built an Access database for about 50 users in my department. Database went
    > through 3rd normalization. I splitted the DB into Front End / Back End; so
    > far things seem to be OK.
    >
    > However, a few other employees of the company (not in my department but have
    > access to the share drive) would also like to access the database. The
    > problem is that they do not have licences of Access. Can they access the
    > database by using the Front End? If not, can they access the database if I
    > save all forms and reports in "Data Access Page" format?
    >
    > Also, if there are no quick fixes, can you give me some links to related
    > articles?
    >
    > Thanks,
    > Adam
     
  4. Norman Yuan

    Norman Yuan
    Expand Collapse
    Guest

    However, you, as developer, must buy the lisence for Access development
    extension to distribute Access runtime.

    "Jen" <Jen@discussions.microsoft.com> wrote in message
    news:8D0AB565-C1BE-41F7-8992-921E6BBA2719@microsoft.com...
    > They can run your frontend using a runtime version of Access. Just create
    > an
    > install that includes the runtime version. j.
    >
    > "Adam Lei" wrote:
    >
    >> I built an Access database for about 50 users in my department. Database
    >> went
    >> through 3rd normalization. I splitted the DB into Front End / Back End;
    >> so
    >> far things seem to be OK.
    >>
    >> However, a few other employees of the company (not in my department but
    >> have
    >> access to the share drive) would also like to access the database. The
    >> problem is that they do not have licences of Access. Can they access the
    >> database by using the Front End? If not, can they access the database if
    >> I
    >> save all forms and reports in "Data Access Page" format?
    >>
    >> Also, if there are no quick fixes, can you give me some links to related
    >> articles?
    >>
    >> Thanks,
    >> Adam
     
  5. Pat Hartman\(MVP\)

    Pat Hartman\(MVP\)
    Expand Collapse
    Guest

    To run an Access application, MS Access must be installed on the local
    computer. If you want to allow people without the retail version of Access
    to run your application, you can purchase the "Visual Studio Tools for
    Microsoft Office System" (A2003). Earlier versions are not for sale from
    Microsoft and are usually referred to as "developer's editions". This
    product contains the runtime version of MS Access plus the packaging and
    deployment wizard along with lots of other software. The product costs
    around $700. It gives you the licenses to distribute unlimited copies of
    the MS Access runtime. There are lots of problems associated with the
    runtime though. You will most likely need to make modifications to your
    application to add error handling and custom menus at a minimum. Search the
    MSDN library and Knowledgebase for articles.

    "Adam Lei" <Adam Lei@discussions.microsoft.com> wrote in message
    news:18E01B48-FFEC-45D0-B362-427ED8E86E39@microsoft.com...
    >I built an Access database for about 50 users in my department. Database
    >went
    > through 3rd normalization. I splitted the DB into Front End / Back End; so
    > far things seem to be OK.
    >
    > However, a few other employees of the company (not in my department but
    > have
    > access to the share drive) would also like to access the database. The
    > problem is that they do not have licences of Access. Can they access the
    > database by using the Front End? If not, can they access the database if I
    > save all forms and reports in "Data Access Page" format?
    >
    > Also, if there are no quick fixes, can you give me some links to related
    > articles?
    >
    > Thanks,
    > Adam
     

Share This Page