DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: MDB or ADP for Multi-user Access database with dial-up connection??

  1. #1
    Vaughan Guest

    MDB or ADP for Multi-user Access database with dial-up connection??


    Hello,

    I am developing a 3 seat Access database where one user will continually
    need to access the database through a dial-up/RAS connection. Despite the
    small size of this database, would the dial-up connection be reason alone
    to upsize to a ADP project with MSDE for the backend?? I am concerned about
    data corruption with a less dependable modem connection.

    I would appreciate any advice/knowledge anyone may have on this. Please
    also CC me at my email address (Vaughan_wb@hotmail.com).

    Thanks,
    Vaughan




  2. #2
    Corey H. Guest

    Re: MDB or ADP for Multi-user Access database with dial-up connection??


    Greetings!

    Vaughan,

    From the start, I don't know much about MSDE. All I can tell you is that
    you make sure you set a "connection time out" property on the database connection.
    Basically, once this person is connected to your RAS system and the database,
    it all comes down to transfering text. Which is probably the lightest thing
    to transfer over dial-up. Dropping connections should not corrupt the database
    but, if it happends to much your database will become very messy and the
    data may become invalid depending on at what point the connection was dropped.

    My ideal would be to create a HTTP SSL site and create your app using ASP
    or PHP for the lang. This way, he/she will not need to dial up to your RAS
    and he/she could just use their existing ISP connection. Microsoft ADO is
    very fast and dosent use that many resources for proccesing transactions.

    ASP and PHP are very easy to code.

    I would deffentaly look for other options then what you are currently planning.

    Good luck mate...




    "Vaughan" <Vaughan_wb@hotmail.com> wrote:
    >
    >Hello,
    >
    >I am developing a 3 seat Access database where one user will continually
    >need to access the database through a dial-up/RAS connection. Despite the
    >small size of this database, would the dial-up connection be reason alone
    >to upsize to a ADP project with MSDE for the backend?? I am concerned about
    >data corruption with a less dependable modem connection.
    >
    >I would appreciate any advice/knowledge anyone may have on this. Please
    >also CC me at my email address (Vaughan_wb@hotmail.com).
    >
    >Thanks,
    >Vaughan
    >
    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center