Re: database question

From: Bob Hairgrove <rhairgroveNoSpam_at_Pleasebigfoot.com>
Date: Tue, 11 Jun 2002 18:44:54 GMT
Message-ID: <3d064470.1142472_at_news.ch.kpnqwest.net>


On Tue, 11 Jun 2002 15:35:44 GMT, "Glenn Daelman" <glenn.daelman_at_pandora.be> wrote:

>What is de best to use to make a database that can be used by tree
>personens at the same time.
>Can i use access and vb to do that.
>Data on the server and program local on the pc
>

Three concurrent users is not a lot ... you can use Access for this, but there are other issues with Access, such as security -- or the lack of it -- and data corruption, as well as limitations on file size which might make you want to look elsewhere to more scalable solutions.

It all depends on several factors:

(a) what kind of data you have;
(b) how much data you have;
(c) how often the data changes;
(d) network situation (Access is not good over a WAN);
(e) security issues;
(f) data sensitivity to corruption;
(g) availability of database (you can't feasibly run Access on a 24/7
schedule).

I'm sure there are more...

Bob Hairgrove
rhairgroveNoSpam_at_Pleasebigfoot.com Received on Tue Jun 11 2002 - 20:44:54 CEST

Original text of this message