Welcome to SPN

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

Sign Up Now!

Terminal access database

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

  1. Mark

    Mark
    Expand Collapse
    Guest

    Ok need advice please...
    I currently have an access database that i would like my friends to access
    and use remotely from their PC's similtanously.
    From what I understand I have to split the database to a frontend and
    backend.Then create a MDE using the frontend so they can gain access and make
    data updates and use it basically but not edit any code or tables/queries
    reports etc.
    I use windows XP, so i am assuming i have to use some terminal software so
    they can be given access to a windows screen where i have installed the
    Frontend MDE(but cant access any other part of my pc)Obviously my host PC has
    to be connected to the internet for them to gain access.
    Is this the best and easiest way to do what i am trying to achieve?
    any free terminal server programs that are useful.also assume i have to use
    the autofe updater if i make changes and so on.
    just want to make sure i am on the right track here.
    thanks heaps
    mark
     
  2. Loading...

    Similar Threads Forum Date
    India India hails $3 billion showpiece airport terminal Breaking News Jul 4, 2010
    Sikh News Coming soon: AC bus terminals with malls, multiplexes in Punjab (Express India) Breaking News May 4, 2008
    Sikh News Rs 5-cr outlay for BOT bus terminals in Punjab (Express India) Breaking News Feb 23, 2008
    Sikh News Punjab to start Satellite Interactive Terminals in schools (New Kerala) Breaking News Jan 11, 2008
    Sikh News Minorities' terminal care studied (BBC News) Breaking News Jun 29, 2005

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    With a Windows XP computer, you have a license for up to 2 simultaneous
    Terminal Services connections. More than that will require a server and a
    Terminal Server license and software. You could also use Citrix. I am
    unaware of any free terminal server that can handle more than a single
    connection, although there is a linux project:

    http://www.ltsp.org/

    that you may want to investigate. My personal experiences with linux have
    been less than satisfying.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Mark" <Mark@discussions.microsoft.com> wrote in message
    news:9295CEC4-28F6-49D8-9310-ECF97966775D@microsoft.com...
    > Ok need advice please...
    > I currently have an access database that i would like my friends to access
    > and use remotely from their PC's similtanously.
    > From what I understand I have to split the database to a frontend and
    > backend.Then create a MDE using the frontend so they can gain access and

    make
    > data updates and use it basically but not edit any code or tables/queries
    > reports etc.
    > I use windows XP, so i am assuming i have to use some terminal software so
    > they can be given access to a windows screen where i have installed the
    > Frontend MDE(but cant access any other part of my pc)Obviously my host PC

    has
    > to be connected to the internet for them to gain access.
    > Is this the best and easiest way to do what i am trying to achieve?
    > any free terminal server programs that are useful.also assume i have to

    use
    > the autofe updater if i make changes and so on.
    > just want to make sure i am on the right track here.
    > thanks heaps
    > mark
    >
     
  4. Danny J. Lesandrini

    Danny J. Lesandrini
    Expand Collapse
    Guest

    Arvin, how do you make two connections to a Windows XP Pro machine?

    When I remote into any machine with Win XP Pro, it bumps the current
    session. So, whether or not you're licensed for two sessions, I've only
    ever gotten one out of it. Is there a registry setting or config property
    to change?
    --

    Danny J. Lesandrini
    dlesandrini@hotmail.com
    http://amazecreations.com/datafast


    "Arvin Meyer [MVP]" <a@m.com> wrote ...
    > With a Windows XP computer, you have a license for up to 2 simultaneous
    > Terminal Services connections. More than that will require a server and a
    > Terminal Server license and software.
     
  5. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Actually, I've made 2 connections FROM an XP machine. I've only made 2
    connections TO a Windows 2000 or 2003 server. I just assumed that since I
    can make 2 connections from, I could also make 2 connections to.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Danny J. Lesandrini" <dlesandrini@hotmail.com> wrote in message
    news:#WBwgV8iGHA.1940@TK2MSFTNGP02.phx.gbl...
    > Arvin, how do you make two connections to a Windows XP Pro machine?
    >
    > When I remote into any machine with Win XP Pro, it bumps the current
    > session. So, whether or not you're licensed for two sessions, I've only
    > ever gotten one out of it. Is there a registry setting or config property
    > to change?
    > --
    >
    > Danny J. Lesandrini
    > dlesandrini@hotmail.com
    > http://amazecreations.com/datafast
    >
    >
    > "Arvin Meyer [MVP]" <a@m.com> wrote ...
    > > With a Windows XP computer, you have a license for up to 2 simultaneous
    > > Terminal Services connections. More than that will require a server and

    a
    > > Terminal Server license and software.

    >
    >
     
  6. Danny J. Lesandrini

    Danny J. Lesandrini
    Expand Collapse
    Guest

    Well, let me put it this way. I have a machine at home that I can access
    remotely, but it's also the only machine that has Spider Solitaire on it. (My
    wife is addicted so we deleted it from her laptop.) So, when she needs a
    fix, she hops on my Win XP Pro machine and launches her game. Then, when
    I try to log on, it bumps her session.

    Now, if there were a 12-step program for Spider Solitaire, it would probably
    approve of my interruption of her game, but for now at least, I think she has
    her addiction under control and I can trust her to stick to a game or two. So,
    I'd like to be able to log in and NOT bump her from the session, but I wasn't
    aware of how that might be done.

    Actually, I should ask the Windows NG, but since this thread was started, it
    seemed like an appropriate question.
    --

    Danny J. Lesandrini
    dlesandrini@hotmail.com
    http://amazecreations.com/datafast


    "Arvin Meyer [MVP]" <a@m.com> wrote ...
    > Actually, I've made 2 connections FROM an XP machine. I've only made 2
    > connections TO a Windows 2000 or 2003 server. I just assumed that since I
    > can make 2 connections from, I could also make 2 connections to.
    > --
    > Arvin Meyer, MCP, MVP
     
  7. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    I know that you can have multiple sessions on a Terminal Server, and you can
    have 2 sessions on a Windows 2000 or 2003 server. Installing a server as
    your OS may just be the ticket. <g>
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Danny J. Lesandrini" <dlesandrini@hotmail.com> wrote in message
    news:e8EOpZijGHA.4512@TK2MSFTNGP02.phx.gbl...
    > Well, let me put it this way. I have a machine at home that I can access
    > remotely, but it's also the only machine that has Spider Solitaire on it.

    (My
    > wife is addicted so we deleted it from her laptop.) So, when she needs a
    > fix, she hops on my Win XP Pro machine and launches her game. Then, when
    > I try to log on, it bumps her session.
    >
    > Now, if there were a 12-step program for Spider Solitaire, it would

    probably
    > approve of my interruption of her game, but for now at least, I think she

    has
    > her addiction under control and I can trust her to stick to a game or two.

    So,
    > I'd like to be able to log in and NOT bump her from the session, but I

    wasn't
    > aware of how that might be done.
    >
    > Actually, I should ask the Windows NG, but since this thread was started,

    it
    > seemed like an appropriate question.
    > --
    >
    > Danny J. Lesandrini
    > dlesandrini@hotmail.com
    > http://amazecreations.com/datafast
    >
    >
    > "Arvin Meyer [MVP]" <a@m.com> wrote ...
    > > Actually, I've made 2 connections FROM an XP machine. I've only made 2
    > > connections TO a Windows 2000 or 2003 server. I just assumed that since

    I
    > > can make 2 connections from, I could also make 2 connections to.
    > > --
    > > Arvin Meyer, MCP, MVP

    >
    >
     
  8. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "Danny J. Lesandrini" <dlesandrini@hotmail.com> wrote:

    >Arvin, how do you make two connections to a Windows XP Pro machine?
    >
    >When I remote into any machine with Win XP Pro, it bumps the current
    >session. So, whether or not you're licensed for two sessions, I've only
    >ever gotten one out of it. Is there a registry setting or config property
    >to change?


    Same thing happens for me. And my friend and I can simultaneously hit
    our Windows 2003 Server.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
  9. Danny J. Lesandrini

    Danny J. Lesandrini
    Expand Collapse
    Guest

    Yeah, I have a Server 2003 machine, but had to delete the games
    off of that one too. The addiction was deep :)
    --
    Danny J. Lesandrini

    "Tony Toews" <ttoews@telusplanet.net> wrote ...
    >
    > Same thing happens for me. And my friend and I can simultaneously hit
    > our Windows 2003 Server.
     
  10. Mark

    Mark
    Expand Collapse
    Guest

    Di some more research and found xpunlimited program works ok, i tried 3
    connections using a remote computer and worked ok. Just slow however but from
    what i am reading its just expected if im only connecting 512k speed to 512k
    speed broadband.


    "Danny J. Lesandrini" wrote:

    > Yeah, I have a Server 2003 machine, but had to delete the games
    > off of that one too. The addiction was deep :)
    > --
    > Danny J. Lesandrini
    >
    > "Tony Toews" <ttoews@telusplanet.net> wrote ...
    > >
    > > Same thing happens for me. And my friend and I can simultaneously hit
    > > our Windows 2003 Server.

    >
    >
    >
     

Share This Page