Hi all, I currently have an app that runs on the BDE w/ paradox and I am
implementing a new module to it and thinking about going with ADO/Access. I
mainly am choosing this route for scalability up to SQL Server and maybe
Advantage Database in the future. What does everything think of the
reliability (mostly of MS Access), and do you suggest any other route? A few
things to note on my app:

1. The app is being distributed to about 900 clients, most have networks of
anywhere from 2-20 machines.

2. My users are not computer savy and have no network admin so install must
be brainless. (except for the limited amounts of people I will be setting up
with MS SQL Server in the future).

3. It needs to be very reliable.

4. Cost needs to be nothing for our customers. Minimal for us.

I know, a lot to ask, any help would be appreciated. Thanks!

Tim A

Access is a nice desktop DB but is not reliable in a multi-user environment.
If scalability to MS SQL is needed then the MSDE is your best option.

HTH
--
Vassil Nazarov
http://web.orbitel.bg/vassil/

There are enough differences between Access and SQL sever that I would not count
on being able to scale well and still have a good performing application. I have
not used Advantage do they have a good ADO driver?  You really do not want to
develop in ADO unless you are working with a database that has a good Ole db
driver to work with.

If you want easy salability use MSDE.  If your application does not require
heavy database use it may be OK all the way to 20 users.  At worst your larger
users will have to purchase SQL server licenses.

If you really want reliability and low cost use the open source version on
Interbase.  However you probably don't want to develop in ADO with Interbase.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Greetings,

    OLE DB providers for Interbase ("ado drivers") can be found in
www.sibprovider.com

    HTH,
    Marcio Wesley Borges

"Brian Bushay TeamB" <BBus...@Nmpls.com> escreveu na mensagem
news:amuortg4atjoubanc2eivfnlkavgh3gef6@4ax.com...

Yes but are any of them reliable and do any support ADO features well?

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

I would offer that if you can get by with MSDE, that would be your
first choice. If not, Access will work, but you may find yourself
spending an inordinate amount of time troubleshooting your client's
network. I've installed quite a few 25-30 user systems and the
majority of the time the problem was the network, not Access.

--

My reply-to address is purposely mangled to thwart auto-reply bots.
Please remove the two leading underscores if you wish to reply via
e-mail.

Greetings Brian,

    Yes, there are SIBPROvider. Test it and if you have problems with it,
please, report me and will help you. We're working to offer the best OLE DB
provider for Interbase/Firebird.

    My best regards,
    Marcio Wesley Borges
    www.sibprovider.com
    "Registering SIBPROvider you're contributing with us to release of new
versions"

"Brian Bushay TeamB" <BBus...@Nmpls.com> escreveu na mensagem
news:s4g1st0oklir5crtf5n0qmgd3e4iq4est6@4ax.com...