Re: Access or SQL Server 2005?





"Darryl Kerkeslager" <kerkeslager@xxxxxxxxxxx> wrote in message
news:ycSdnVEnzbYrIp7ZnZ2dnUVZ_t6dnZ2d@xxxxxxxxxxxxxx
While this may seem huge, once it is split up into tables and
"normalized",
it may not be as big as it seems, and may grow much more slowly.

Excellent point. It should actually shrink quite a bit once "normalized."

Assuming you have a LAN for these users, the database will probably be
trivial. Don't go overboard - no need to spend a fortune, here.

I have a LAN, and DSL is distributed to users on a "need email" basis.
The cost is remarkably low for me, as I have a ton of software from
Microsoft, and piles of hardware.
Just working on what to do with it.

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.

I have multi-user lic. for...

SQL server.
Office Pro 2003
Windows Server 2003
Windows XP Pro

Can the users running Access, use a database stored on the server in SQL
Server?


.



Relevant Pages

  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Best replication architecture?
    ... Looking for a SQL Server replication book? ... So if it is subscribing to Publisher 1, ...
    (microsoft.public.sqlserver.replication)
  • RE: Insufficient memory Available
    ... Insufficient memory available. ... within the scope of SQL Server. ... "MemToLeave" area. ...
    (microsoft.public.sqlserver.server)