Re: Why is no one USING the product for small business?
From: Gary (gwilkins_at_#no.spam#vtiboston.com)
Date: 09/13/04
- Next message: Gary: "Re: DB opens in read only mode"
- Previous message: Van T. Dinh: "Re: Append Query Question"
- In reply to: John Nurick: "Re: Why is no one USING the product for small business?"
- Next in thread: Albert D. Kallal: "Re: Why is no one USING the product for small business?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 13 Sep 2004 16:41:37 -0400
Hey,
We have a small/medium business and we use Access for almost everything.
Recently our order entry databases were converted to SQL, but they remain
Access on top.
One problem with Access is that Jet (the network protocol it uses) can be
very slow, resulting in slow load times. At least that's what we've noticed
here. Converted to a SQL back-end and it went away.
Access can be a very nice development tool, but Microsoft doesn't target
network and corporate users with Access. There is no "Microsoft Access for
Networks" version. There's Access, by itself, OK for small companies with
one or a few users, then there is the world of SQL which larger entities
use. So the development question remains, what sort of environment are you
working in?
If you are starting out (as you say) in a 'small business' Access might be a
great fit for you. You can upsize to a SQL database later if you need to. I
wouldn't say nobody uses it, but those that don't use it have some good
reasons why they don't. Slow, troublesome performance is what I most notice
our users complain most about.
We have between 20 and 50 users (generally) attached over a network at the
same time, so it most certainly is not true that you can't share a database.
You just have to make sure that all users open up the database for Shared
Access and not Exclusive Access.
HTH,
Gary
"John Nurick" <j.mapSoN.nurick@dial.pipex.com> wrote in message
news:srqbk0tc34jmqoheq5rn7cp3p9jeh58ft7@4ax.com...
> Hi Jaycee,
>
> Regulars here know lots of large and small businesses that _are_ using
> Access. (I work for one.) I'll leave others to fill in the reasons -
> good and bad - why other businesses don't use it.
>
> It is emphatically not true that only one user on a network can do data
> entry. When Access is used as the front end for a database server (e.g.
> SQL Server or Oracle), the only limit is imposed by the server hardware
> and software (from tens to tens of thousands of users).
>
> With the traditional "all-Access" setup, with the data in a shared MDB
> file on the server and the user interface in a "front end" MDB on each
> workstation, Access's theoretical limit is 255 simultaneous users, and
> the practical limit for simultaneous data entry is generally between
> about 5 and 30 depending on the hardware, the intensity of usage, and
> just how the database is set up.
>
> (There's a difference between data entry and database design: the latter
> typically requires exclusive access to the MDB file, but this isn't an
> issue if - as there should be - each user has their own copy of the
> front end MDB.)
>
>
> On Mon, 13 Sep 2004 10:17:09 -0700, jayceejay
> <jayceejay@discussions.microsoft.com> wrote:
>
> >What gives with Access? I spent a ton of time studying how to use it,
and
> >now I find that few people (even SMALL businesses) are using it. Why is
that?
> >
> >I had hoped to use it myself for my own business, but am now shying away.
> >Is it true, for example, that only one user in a network can do data
entry at
> >a time?
> >
> >Jayceejay
>
> --
> John Nurick [Microsoft Access MVP]
>
> Please respond in the newgroup and not by email.
- Next message: Gary: "Re: DB opens in read only mode"
- Previous message: Van T. Dinh: "Re: Append Query Question"
- In reply to: John Nurick: "Re: Why is no one USING the product for small business?"
- Next in thread: Albert D. Kallal: "Re: Why is no one USING the product for small business?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
