Welcome to SPN

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

Sign Up Now!

access working on a server

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

  1. thread

    thread
    Expand Collapse
    Guest

    hi all,
    i'm going to poblish my access file after dividing it to 2(db and
    aplications/quries)
    i would like to know what is the best solution for using the access on
    the server and what is the best server of course,i know that there is a
    server called IIS but does it works with access file or i need to
    change all the platform of my dababase?
     
  2. Loading...


  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    "thread" <yaniv.dg@gmail.com> wrote in message
    news:1151139403.926181.241980@c74g2000cwc.googlegroups.com...
    > hi all,
    > i'm going to poblish my access file after dividing it to 2(db and
    > aplications/quries)
    > i would like to know what is the best solution for using the access on
    > the server and what is the best server of course,i know that there is a
    > server called IIS but does it works with access file or i need to
    > change all the platform of my dababase?


    In a standard split-app setup you save the data file on the server and give all
    users full permissions to that folder. Then the front end is installed on each
    user's PC along with Microsoft Access (licensed or the runtime).

    The server is merely serving the file. That's it. Think of it as a remote hard
    drive. There is no requirement for any other software to be installed on it.
    Your app is not running ON the server. It is running on each user's PC.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  4. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    IIS is an internet server not a file server. You can use Access with IIS,
    but not with the application front end. Instead you'll need to build ASP
    pages to use it. If you want to use Access on a network, the best solution
    is a file server like Windows Server 2003.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "thread" <yaniv.dg@gmail.com> wrote in message
    news:1151139403.926181.241980@c74g2000cwc.googlegroups.com...
    > hi all,
    > i'm going to poblish my access file after dividing it to 2(db and
    > aplications/quries)
    > i would like to know what is the best solution for using the access on
    > the server and what is the best server of course,i know that there is a
    > server called IIS but does it works with access file or i need to
    > change all the platform of my dababase?
    >
     
  5. thread

    thread
    Expand Collapse
    Guest

    hi rick
    after talking with our IT department they are not accepting office file
    on the server but one thing that they say and i want to consule you
    regarding this issue is that this front-end file cannot stand a
    multiple use of users and after some time it can crush down,what do you
    say about this?

    Rick Brandt כתב:
    > "thread" <yaniv.dg@gmail.com> wrote in message
    > news:1151139403.926181.241980@c74g2000cwc.googlegroups.com...
    > > hi all,
    > > i'm going to poblish my access file after dividing it to 2(db and
    > > aplications/quries)
    > > i would like to know what is the best solution for using the access on
    > > the server and what is the best server of course,i know that there is a
    > > server called IIS but does it works with access file or i need to
    > > change all the platform of my dababase?

    >
    > In a standard split-app setup you save the data file on the server and give all
    > users full permissions to that folder. Then the front end is installed on each
    > user's PC along with Microsoft Access (licensed or the runtime).
    >
    > The server is merely serving the file. That's it. Think of it as a remote hard
    > drive. There is no requirement for any other software to be installed onit.
    > Your app is not running ON the server. It is running on each user's PC.
    >
    > --
    > Rick Brandt, Microsoft Access MVP
    > Email (as appropriate) to...
    > RBrandt at Hunter dot com
     
  6. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Sounds as though your IT department doesn't know what they're talking about.

    If they don't allow office files on the server, how are multiple users going
    to access the same file?

    If you follow Rick's advice and ensure that each user has his/her own copy
    of the front-end database on his/her hard drive (with the shared back-end
    database on the server), you should be fine.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "thread" <yaniv.dg@gmail.com> wrote in message
    news:1151358459.552784.135400@y41g2000cwy.googlegroups.com...
    hi rick
    after talking with our IT department they are not accepting office file
    on the server but one thing that they say and i want to consule you
    regarding this issue is that this front-end file cannot stand a
    multiple use of users and after some time it can crush down,what do you
    say about this?

    Rick Brandt ???:
    > "thread" <yaniv.dg@gmail.com> wrote in message
    > news:1151139403.926181.241980@c74g2000cwc.googlegroups.com...
    > > hi all,
    > > i'm going to poblish my access file after dividing it to 2(db and
    > > aplications/quries)
    > > i would like to know what is the best solution for using the access on
    > > the server and what is the best server of course,i know that there is a
    > > server called IIS but does it works with access file or i need to
    > > change all the platform of my dababase?

    >
    > In a standard split-app setup you save the data file on the server and
    > give all
    > users full permissions to that folder. Then the front end is installed on
    > each
    > user's PC along with Microsoft Access (licensed or the runtime).
    >
    > The server is merely serving the file. That's it. Think of it as a
    > remote hard
    > drive. There is no requirement for any other software to be installed on
    > it.
    > Your app is not running ON the server. It is running on each user's PC.
    >
    > --
    > Rick Brandt, Microsoft Access MVP
    > Email (as appropriate) to...
    > RBrandt at Hunter dot com
     
  7. thread

    thread
    Expand Collapse
    Guest

    hi Douglas,
    the question is if there will be from time to time update of data to
    the server file(db),is it still be holding on or it will crush down
    after some time?becaouse the data to the main db will need to be
    updated from time to time by submission

    Douglas J. Steele wrote:
    > Sounds as though your IT department doesn't know what they're talking about.
    >
    > If they don't allow office files on the server, how are multiple users going
    > to access the same file?
    >
    > If you follow Rick's advice and ensure that each user has his/her own copy
    > of the front-end database on his/her hard drive (with the shared back-end
    > database on the server), you should be fine.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no private e-mails, please)
    >
    >
    > "thread" <yaniv.dg@gmail.com> wrote in message
    > news:1151358459.552784.135400@y41g2000cwy.googlegroups.com...
    > hi rick
    > after talking with our IT department they are not accepting office file
    > on the server but one thing that they say and i want to consule you
    > regarding this issue is that this front-end file cannot stand a
    > multiple use of users and after some time it can crush down,what do you
    > say about this?
    >
    > Rick Brandt ???:
    > > "thread" <yaniv.dg@gmail.com> wrote in message
    > > news:1151139403.926181.241980@c74g2000cwc.googlegroups.com...
    > > > hi all,
    > > > i'm going to poblish my access file after dividing it to 2(db and
    > > > aplications/quries)
    > > > i would like to know what is the best solution for using the access on
    > > > the server and what is the best server of course,i know that there is a
    > > > server called IIS but does it works with access file or i need to
    > > > change all the platform of my dababase?

    > >
    > > In a standard split-app setup you save the data file on the server and
    > > give all
    > > users full permissions to that folder. Then the front end is installed on
    > > each
    > > user's PC along with Microsoft Access (licensed or the runtime).
    > >
    > > The server is merely serving the file. That's it. Think of it as a
    > > remote hard
    > > drive. There is no requirement for any other software to be installed on
    > > it.
    > > Your app is not running ON the server. It is running on each user's PC.
    > >
    > > --
    > > Rick Brandt, Microsoft Access MVP
    > > Email (as appropriate) to...
    > > RBrandt at Hunter dot com
     
  8. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    There's always a chance of corruption in any system, but without more
    details of number of users, volume of data, split between read-only usage
    vs. update usage and the like, I'd say that you should be okay.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "thread" <yaniv.dg@gmail.com> wrote in message
    news:1151385582.698415.105740@y41g2000cwy.googlegroups.com...
    > hi Douglas,
    > the question is if there will be from time to time update of data to
    > the server file(db),is it still be holding on or it will crush down
    > after some time?becaouse the data to the main db will need to be
    > updated from time to time by submission
    >
    > Douglas J. Steele wrote:
    > > Sounds as though your IT department doesn't know what they're talking

    about.
    > >
    > > If they don't allow office files on the server, how are multiple users

    going
    > > to access the same file?
    > >
    > > If you follow Rick's advice and ensure that each user has his/her own

    copy
    > > of the front-end database on his/her hard drive (with the shared

    back-end
    > > database on the server), you should be fine.
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no private e-mails, please)
    > >
    > >
    > > "thread" <yaniv.dg@gmail.com> wrote in message
    > > news:1151358459.552784.135400@y41g2000cwy.googlegroups.com...
    > > hi rick
    > > after talking with our IT department they are not accepting office file
    > > on the server but one thing that they say and i want to consule you
    > > regarding this issue is that this front-end file cannot stand a
    > > multiple use of users and after some time it can crush down,what do you
    > > say about this?
    > >
    > > Rick Brandt ???:
    > > > "thread" <yaniv.dg@gmail.com> wrote in message
    > > > news:1151139403.926181.241980@c74g2000cwc.googlegroups.com...
    > > > > hi all,
    > > > > i'm going to poblish my access file after dividing it to 2(db and
    > > > > aplications/quries)
    > > > > i would like to know what is the best solution for using the access

    on
    > > > > the server and what is the best server of course,i know that there

    is a
    > > > > server called IIS but does it works with access file or i need to
    > > > > change all the platform of my dababase?
    > > >
    > > > In a standard split-app setup you save the data file on the server and
    > > > give all
    > > > users full permissions to that folder. Then the front end is

    installed on
    > > > each
    > > > user's PC along with Microsoft Access (licensed or the runtime).
    > > >
    > > > The server is merely serving the file. That's it. Think of it as a
    > > > remote hard
    > > > drive. There is no requirement for any other software to be installed

    on
    > > > it.
    > > > Your app is not running ON the server. It is running on each user's

    PC.
    > > >
    > > > --
    > > > Rick Brandt, Microsoft Access MVP
    > > > Email (as appropriate) to...
    > > > RBrandt at Hunter dot com

    >
     
  9. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    The database files need to be split. The applications go on each
    workstation. Only the datatables go on the server. I support over 50 users
    each with files on their individual machines, all of whom are linked to the
    data files on the server. Our last corruption was caused by a faulty WiFi
    card in April of 2003. Your IT department obviously suffers from a lack of
    knowledge.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "thread" <yaniv.dg@gmail.com> wrote in message
    news:1151385582.698415.105740@y41g2000cwy.googlegroups.com...
    > hi Douglas,
    > the question is if there will be from time to time update of data to
    > the server file(db),is it still be holding on or it will crush down
    > after some time?becaouse the data to the main db will need to be
    > updated from time to time by submission
    >
    > Douglas J. Steele wrote:
    >> Sounds as though your IT department doesn't know what they're talking
    >> about.
    >>
    >> If they don't allow office files on the server, how are multiple users
    >> going
    >> to access the same file?
    >>
    >> If you follow Rick's advice and ensure that each user has his/her own
    >> copy
    >> of the front-end database on his/her hard drive (with the shared back-end
    >> database on the server), you should be fine.
    >>
    >> --
    >> Doug Steele, Microsoft Access MVP
    >> http://I.Am/DougSteele
    >> (no private e-mails, please)
    >>
    >>
    >> "thread" <yaniv.dg@gmail.com> wrote in message
    >> news:1151358459.552784.135400@y41g2000cwy.googlegroups.com...
    >> hi rick
    >> after talking with our IT department they are not accepting office file
    >> on the server but one thing that they say and i want to consule you
    >> regarding this issue is that this front-end file cannot stand a
    >> multiple use of users and after some time it can crush down,what do you
    >> say about this?
    >>
    >> Rick Brandt ???:
    >> > "thread" <yaniv.dg@gmail.com> wrote in message
    >> > news:1151139403.926181.241980@c74g2000cwc.googlegroups.com...
    >> > > hi all,
    >> > > i'm going to poblish my access file after dividing it to 2(db and
    >> > > aplications/quries)
    >> > > i would like to know what is the best solution for using the access
    >> > > on
    >> > > the server and what is the best server of course,i know that there is
    >> > > a
    >> > > server called IIS but does it works with access file or i need to
    >> > > change all the platform of my dababase?
    >> >
    >> > In a standard split-app setup you save the data file on the server and
    >> > give all
    >> > users full permissions to that folder. Then the front end is installed
    >> > on
    >> > each
    >> > user's PC along with Microsoft Access (licensed or the runtime).
    >> >
    >> > The server is merely serving the file. That's it. Think of it as a
    >> > remote hard
    >> > drive. There is no requirement for any other software to be installed
    >> > on
    >> > it.
    >> > Your app is not running ON the server. It is running on each user's
    >> > PC.
    >> >
    >> > --
    >> > Rick Brandt, Microsoft Access MVP
    >> > Email (as appropriate) to...
    >> > RBrandt at Hunter dot com

    >
     

Share This Page