Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    386

    Unanswered: Is it possible to make Acess 2002 like an online Database

    We have an access database with many forms, reports, and tables and obviously with a lot of data in it. I would like to know whether it is possible to use this database online so that users can login to their database in the same way as when then are using it on their desktops.

    More information: We will obviously want to be able to use the Forms and Reports in exactly the same way as they are.

    Any advice and tips would be much appreciated.
    Emi-UK
    Love begets Love, Help Begets Help

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Exactly No
    Access doesnt' scale well when used on a WAN/over the internet in a multi user environment. you may be able to say transfer a copy of the db to the remote user, let them do whatever they need locally, then transfer back the changed db

    if your users need to they can use a copy of the Access runtime FoC for A2007 and later, for earlier versions the runtime is chargeable, but you can use earlier DB's in the more modern runtime

    No file sharing DB scales well
    .. what you could do though is use a server backend that provides the data remotely within Access.. but thats probably going to need a complete re design of the back end and the way forms and reports interact
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •