Welcome to SPN

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

Sign Up Now!

database question

Discussion in 'Information Technology' started by Pam Coleman, Nov 4, 2005.

  1. Pam Coleman

    Pam Coleman
    Expand Collapse
    Guest

    If I have a database in Access and am writing a .net program but I want to
    use link to that Access database, question: when it is installed on other
    PC's do they have to have Access loaded in order for my program to run
     
  2. Loading...

    Similar Threads Forum Date
    USA NSA has massive database of Americans' phone calls (USA Today 5.11.2006) Breaking News Jun 11, 2013
    Some database errors while navigating SPN forums Announcements Dec 29, 2004
    Question About GGS Questions and Answers Aug 28, 2016
    Marriage And Discrimination Related Questions Blogs Mar 21, 2016
    Sikhi Questioning Faith Sikh Sikhi Sikhism Mar 3, 2016

  3. Lynn Trapp

    Lynn Trapp
    Expand Collapse
    Guest

    My understand is that, if you simply want to link to the tables in a .mdb
    file, the users would not need to have an Access license. Others may be able
    to give better information on that.

    --
    Lynn Trapp
    MS Access MVP
    www.ltcomputerdesigns.com
    Access Security: www.ltcomputerdesigns.com/Security.htm
    Jeff Conrad's Access Junkie List:
    http://home.bendbroadband.com/conradsystems/accessjunkie.html



    "Pam Coleman" <PamColeman@discussions.microsoft.com> wrote in message
    news:C5321E00-A729-40B9-BCB6-6F30BB1BCE48@microsoft.com...
    > If I have a database in Access and am writing a .net program but I want to
    > use link to that Access database, question: when it is installed on other
    > PC's do they have to have Access loaded in order for my program to run
     
  4. Pam Coleman

    Pam Coleman
    Expand Collapse
    Guest

    I was wanting to know if it would work at all, some of co-workers said it
    wouldn't work if Access was not loaded. Thanks,

    "Lynn Trapp" wrote:

    > My understand is that, if you simply want to link to the tables in a .mdb
    > file, the users would not need to have an Access license. Others may be able
    > to give better information on that.
    >
    > --
    > Lynn Trapp
    > MS Access MVP
    > www.ltcomputerdesigns.com
    > Access Security: www.ltcomputerdesigns.com/Security.htm
    > Jeff Conrad's Access Junkie List:
    > http://home.bendbroadband.com/conradsystems/accessjunkie.html
    >
    >
    >
    > "Pam Coleman" <PamColeman@discussions.microsoft.com> wrote in message
    > news:C5321E00-A729-40B9-BCB6-6F30BB1BCE48@microsoft.com...
    > > If I have a database in Access and am writing a .net program but I want to
    > > use link to that Access database, question: when it is installed on other
    > > PC's do they have to have Access loaded in order for my program to run

    >
    >
    >
     
  5. Lynn Trapp

    Lynn Trapp
    Expand Collapse
    Guest

    You're welcome. Just to clarify, if you want to open the .mdb file using
    Access, then you need to have some version of Access installed. However,
    the Jet database that is stored in a .mdb file may be put on any computer
    and linked to from another application without a license.

    --
    Lynn Trapp
    MS Access MVP
    www.ltcomputerdesigns.com
    Access Security: www.ltcomputerdesigns.com/Security.htm
    Jeff Conrad's Access Junkie List:
    http://home.bendbroadband.com/conradsystems/accessjunkie.html



    "Pam Coleman" <PamColeman@discussions.microsoft.com> wrote in message
    news:29254E22-3945-46AF-BB14-E882F2707CFB@microsoft.com...
    >I was wanting to know if it would work at all, some of co-workers said it
    > wouldn't work if Access was not loaded. Thanks,
    >
    > "Lynn Trapp" wrote:
    >
    >> My understand is that, if you simply want to link to the tables in a .mdb
    >> file, the users would not need to have an Access license. Others may be
    >> able
    >> to give better information on that.
    >>
    >> --
    >> Lynn Trapp
    >> MS Access MVP
    >> www.ltcomputerdesigns.com
    >> Access Security: www.ltcomputerdesigns.com/Security.htm
    >> Jeff Conrad's Access Junkie List:
    >> http://home.bendbroadband.com/conradsystems/accessjunkie.html
    >>
    >>
    >>
    >> "Pam Coleman" <PamColeman@discussions.microsoft.com> wrote in message
    >> news:C5321E00-A729-40B9-BCB6-6F30BB1BCE48@microsoft.com...
    >> > If I have a database in Access and am writing a .net program but I want
    >> > to
    >> > use link to that Access database, question: when it is installed on
    >> > other
    >> > PC's do they have to have Access loaded in order for my program to run

    >>
    >>
    >>
     
  6. George Nicholson

    George Nicholson
    Expand Collapse
    Guest

    I can't speak to .net, but vb 6 can build apps that connect to .mdb (Jet
    database files) *data and queries*. These apps do not require Access.

    Reports (and forms, but why would you want to..?) in that .mdb file would
    require Access, so you have to roll-your-own reports in VB.

    Lots of programs can read & write data to .mdb files (for instance, Excel)
    and they don't require Access for that to happen. You do need an Access
    license if you want to use Access Forms, Reports, etc.

    HTH,
    --
    George Nicholson

    Remove 'Junk' from return address.


    "Pam Coleman" <PamColeman@discussions.microsoft.com> wrote in message
    news:29254E22-3945-46AF-BB14-E882F2707CFB@microsoft.com...
    >I was wanting to know if it would work at all, some of co-workers said it
    > wouldn't work if Access was not loaded. Thanks,
    >
    > "Lynn Trapp" wrote:
    >
    >> My understand is that, if you simply want to link to the tables in a .mdb
    >> file, the users would not need to have an Access license. Others may be
    >> able
    >> to give better information on that.
    >>
    >> --
    >> Lynn Trapp
    >> MS Access MVP
    >> www.ltcomputerdesigns.com
    >> Access Security: www.ltcomputerdesigns.com/Security.htm
    >> Jeff Conrad's Access Junkie List:
    >> http://home.bendbroadband.com/conradsystems/accessjunkie.html
    >>
    >>
    >>
    >> "Pam Coleman" <PamColeman@discussions.microsoft.com> wrote in message
    >> news:C5321E00-A729-40B9-BCB6-6F30BB1BCE48@microsoft.com...
    >> > If I have a database in Access and am writing a .net program but I want
    >> > to
    >> > use link to that Access database, question: when it is installed on
    >> > other
    >> > PC's do they have to have Access loaded in order for my program to run

    >>
    >>
    >>
     

Share This Page