Re:Delphi/ADO deployment
10 network users and 10 concurrent connections are different. If you need to
present data to users you can use client-side cursor (default in ADO Express
or dbGo) - the traffic to/from database will be minimal (if you do not plan
work very intensive with database). Access is very good choice and later you
will can go to MS SQL Server (MSDE, for example) with little efforts. Cost
to clients is 0 and Jet is installed on most computers. The main minus is
that Access is not cross-platform.
----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server and MS Jet (MS Access) databases.
"Ana Ribeiro" <aribe...@e-pay.co.uk> ????/???? a ?a???? ????t??:
news:3da3f493@newsgroups.borland.com...
Quote
> Thanks for the answer.
> I'm worried about what you said with regards to Access db and multi-user.
> No-one else in the newsgroup had mention concerns before...
> I'm soon to start the development of another app, and I was intending to
use
> Access again (the app will also be used in networks of max 10 users). If
> Access is not a good idea, what is? (considering the costs to the client
> must be kept to a minimum).
> Thanks
> Ana
> "Philippe Damerval" <-> wrote in message
> news:3da363bb$1@newsgroups.borland.com...
> > Ana,
> > Please give us more information. If it is a classic schema, then you
> > probably want to install your application on each machine and keep your
> > access data file (btw, BAD idea, I haven't yet seen a working solution
> where
> > access and ADO were used in a multi-user environment. It is possible in
> > theory but in practice there are a lot of problems) centrally, on one of
> the
> > machines or ideally on a dedicated server.
> > Each machine will need to have MDAC installed, the latest version is 2.7
> but
> > it is bugged, try 2.6 if you can still get hold of a copy of it.
> > Each machine will also need to have a udl file pointing to your central
> > access database.
> > If you secure your database, make sure you keep the admin password safe
> > because an access database file without its original system.mdw can only
> be
> > opened with the admin password.
> > As I said, please give us more information and ask your questions more
> > specifically.
> > P.
> > "Ana Ribeiro" <aribe...@e-pay.co.uk> wrote in message
> > news:3da2f7bc$1@newsgroups.borland.com...
> > > Hello
> > > I'm developing a small Delphi/ADO app with an Access DB.
> > > I want to deploy it to a network of no more than 5 users.
> > > It's the first time I am doing this, and I have no idea what to do. Do
I
> > use
> > > Install shield to create the installation cd, install it on one
machine,
> > and
> > > then create shortcuts on the other machines, or do I have to install
it
> in
> > > each machine?
> > > Thanks
> > > Ana Ribeiro
