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
>
>
>