Re: Access or SQL Server 2005?
- From: "David W. Fenton" <XXXusenet@xxxxxxxxxxxxxxxxxxx>
- Date: Tue, 28 Feb 2006 14:08:01 -0600
"analyst" <no@xxxxxxxx> wrote in news:du25lp0vnu@xxxxxxxxxxxxxxxxxx:
Actually writing a list shows me up to 16 users could possibly
access the database at once.
I think that means I need it to happen in SQL Server, unless
Access 2003 can get there.
No, not at all -- that's still well within the range of Access/Jet's
capabilities. We've had plenty of reports of people running with 50
users, and no small number of reports of apps with 100 or so users,
all built on Access/Jet.
[]
Can the users running Access, use a database stored on the server
in SQL Server?
That's the whole idea of having a SQL Server, yes.
But I don't think you should get into that until you've developed
the app all in Access. If you have problems then you can upsize to
SQL Server. However, it's unlikely that an unchanged application
design will be improved by merely moving the back end to SQL Server.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.
- References:
- Access or SQL Server 2005?
- From: analyst
- Re: Access or SQL Server 2005?
- From: Darryl Kerkeslager
- Re: Access or SQL Server 2005?
- From: analyst
- Access or SQL Server 2005?
- Prev by Date: Re: Access or SQL Server 2005?
- Next by Date: Importing multiple files..
- Previous by thread: Re: Access or SQL Server 2005?
- Next by thread: Who started me?
- Index(es):
Relevant Pages
|
