Welcome to SPN

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

Sign Up Now!

Can I put an exsisting database on a website

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

  1. stillb

    stillb
    Expand Collapse
    Guest

    I need to make an exsisting database accesable to other offices. Can this be
    done by putting on a web page? If so How? I'm using Access 2003
     
  2. Loading...


  3. ldiaz

    ldiaz
    Expand Collapse
    Guest

    I think is better to share the Access Data Base putting it in a shared drive.
    so many people can access to your aplication.

    LD

    --
    Lorenzo Díaz
    Cad Technician


    "stillb" wrote:

    > I need to make an exsisting database accesable to other offices. Can this be
    > done by putting on a web page? If so How? I'm using Access 2003
     
  4. stillb

    stillb
    Expand Collapse
    Guest

    The other offices are in diffrent parts of the country and possibly overseas.
    Does this change things?

    "ldiaz" wrote:

    >
    > I think is better to share the Access Data Base putting it in a shared drive.
    > so many people can access to your aplication.
    >
    > LD
    >
    > --
    > Lorenzo Díaz
    > Cad Technician
    >
    >
    > "stillb" wrote:
    >
    > > I need to make an exsisting database accesable to other offices. Can this be
    > > done by putting on a web page? If so How? I'm using Access 2003
     
  5. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    Of course it does, and even if they were in the same city, unless they were
    on a high-speed Lan, Lorenzo's solution would not apply. There are several
    ways that you can share the _data_, but all of them require a different user
    interface. Data Access Pages, because of their limitations, are useful only
    for simple access on intranets (and it has been stated that they will be
    "deprecated" in the next version of Office), FrontPage 2002 or 2003 with the
    Data Interaction Wizard can also provide Read and Write access of a very
    simple nature (but the FrontPage product is being dropped with the next
    version of Office), there are third-party products such as ColdFusion that
    can work with the Tables of an Access database with a re-written user
    interface; Microsoft's ActiveX Server Pages .asp pages and the newer ASP.NET
    can use Access tables but also require a complete rewrite of the user
    interface. Only with advanced features of the .NET environment could you
    begin to approach the richness of interface provided by Access itself.

    A possible alternative is to use "remote access" software and allow the
    remote users to run on your local machine. This can range from simple
    products such as Reach Out, or PC Anywhere, which can be very slow over an
    Internet or dialup connection to more advanced Virtual Private Networks
    (VPN) supporting Microsoft Terminal Server or Citrix MetaFrame. In this
    case, too, the remote users would actually be running software on your local
    machine.

    Larry Linson
    Microsoft Access MVP

    "stillb" wrote
    > The other offices are in diffrent parts of
    > the country and possibly overseas.
    > Does this change things?


    > "ldiaz" wrote:
    >
    >> I think is better to share the Access Data
    >> Base putting it in a shared drive.
    >> so many people can access to your aplication.
    >> Lorenzo Díaz


    >> "stillb" wrote:
    >>
    >> > I need to make an exsisting database
    >> >accesable to other offices. Can this be
    >> > done by putting on a web page? If so
    >> > How? I'm using Access 2003
     
  6. Gary Walter

    Gary Walter
    Expand Collapse
    Guest

    "stillb" wrote:
    > The other offices are in diffrent parts of the country and possibly
    > overseas.
    > Does this change things?
    >

    Here *might* be a solution that has worked for us....

    If you could dedicate a local computer for each
    of your distant users, GoToMyPC has worked
    well for us.

    A valuable woman at our company had a "life change."
    Actually, it was her husband, who quit academic life
    and became a "horse whisperer" teacher. They go to
    Colorado in the summer, and Florida in the winter.

    She has her own regular, local computer at our company
    which she uses when she is in the office.

    All our Access dbs are split, with backends on a server
    and each user getting a frontend on their computer.

    Where ever she goes (she was up in Maine recently to
    help her son and his wife who are expecting), she finds
    *any* Internet connection, goes to GoToMyPC's website
    and *securely* logs in to her computer here.

    She ends up using her office computer like she was
    sitting here in front of it.

    The connection is initiated through common https so
    nobody has to have any special ports open.
    No router/firewall impediments so far.

    And we don't have to worry about one more
    Citrix/Windows 2003 server needing patches to
    correct one more vulnerablility (and will this patch
    break our server). It's all handled by Citrix people
    at GoToMyPC.

    Sure, we pay for the service (whereas an alternative
    such a Himachi might be free), but we gladly pay the
    small yearly fee to know she will always be able to
    connect securely anytime, from anywhere.

    She has mostly had broadband available to her, and
    the Access db's perform just like if she were there in
    the office.

    Plus, she's an off-hours MAC freak and she gets to use
    her new core-duo MacBook to run her office Windows
    machine.

    While not applicable to your case, she also does not
    have to worry about synching Outlook!

    As far as dial-up performance, I also have an account
    and will connect in from my home dial-up (~44 Kbps)
    sometimes to do db maintenance early in the morning,
    or if they need something run /changed while I am at
    home coding. There is a very-slight sluggishness when the
    screen updates in Access, but not disagreeably so.

    It has been a God-send for us.
     
  7. stillb

    stillb
    Expand Collapse
    Guest

    Thanks Gary,
    I will look into this and see if it will work for us to.
    again thanks
    Bill

    "Gary Walter" wrote:

    > "stillb" wrote:
    > > The other offices are in diffrent parts of the country and possibly
    > > overseas.
    > > Does this change things?
    > >

    > Here *might* be a solution that has worked for us....
    >
    > If you could dedicate a local computer for each
    > of your distant users, GoToMyPC has worked
    > well for us.
    >
    > A valuable woman at our company had a "life change."
    > Actually, it was her husband, who quit academic life
    > and became a "horse whisperer" teacher. They go to
    > Colorado in the summer, and Florida in the winter.
    >
    > She has her own regular, local computer at our company
    > which she uses when she is in the office.
    >
    > All our Access dbs are split, with backends on a server
    > and each user getting a frontend on their computer.
    >
    > Where ever she goes (she was up in Maine recently to
    > help her son and his wife who are expecting), she finds
    > *any* Internet connection, goes to GoToMyPC's website
    > and *securely* logs in to her computer here.
    >
    > She ends up using her office computer like she was
    > sitting here in front of it.
    >
    > The connection is initiated through common https so
    > nobody has to have any special ports open.
    > No router/firewall impediments so far.
    >
    > And we don't have to worry about one more
    > Citrix/Windows 2003 server needing patches to
    > correct one more vulnerablility (and will this patch
    > break our server). It's all handled by Citrix people
    > at GoToMyPC.
    >
    > Sure, we pay for the service (whereas an alternative
    > such a Himachi might be free), but we gladly pay the
    > small yearly fee to know she will always be able to
    > connect securely anytime, from anywhere.
    >
    > She has mostly had broadband available to her, and
    > the Access db's perform just like if she were there in
    > the office.
    >
    > Plus, she's an off-hours MAC freak and she gets to use
    > her new core-duo MacBook to run her office Windows
    > machine.
    >
    > While not applicable to your case, she also does not
    > have to worry about synching Outlook!
    >
    > As far as dial-up performance, I also have an account
    > and will connect in from my home dial-up (~44 Kbps)
    > sometimes to do db maintenance early in the morning,
    > or if they need something run /changed while I am at
    > home coding. There is a very-slight sluggishness when the
    > screen updates in Access, but not disagreeably so.
    >
    > It has been a God-send for us.
    >
    >
    >
    >
     

Share This Page