Re: Access or SQL Server 2005?

I recounted...
16 users could actually access the data file at once.


With 10 simultaneous users, you really ought to run a standalone
server, so have one machine with Windows Server 2003.

That does look like the best plan of all I have seen and heard so far.


If you have concurrency problems in an all-Access, you can install
SQL Server and upgrade the back-end data file to SQL Server.

I'm not sure if this means everyone needs to be an SQL client, or just the
server.
I have an Excel file that queries an Access datafile for customer ID. Is
this the same idea?

If it is, are there pros and cons that favor users running Access vs SQL?
(other than price - no object here)

THANKS!!


.

Relevant Pages

  • Re: Full-text indexing and Windows 2003 Server
    ... an OS upgrade from Windows 2000 Server (an ... SQL Server 2000 Full-text ... Server 2000 FTS on Windows 2000 vs. Windows Server 2003..." ...
    (microsoft.public.sqlserver.fulltext)
  • Cannot open SMS console
    ... I cannot open the SMS console. ... SMS Server OS: Windows 2003 Server Standard Edition SQL ... SQL Server Standard Edition 2000 SP3a ... Security Update for Windows Server 2003 ...
    (microsoft.public.sms.admin)
  • Re: Performance problem with an ASP.NET application - XP far quicker than W2K3 Server!
    ... It sounds like you've researched this properly and have now confirmed the network is not the issue. ... It would be interesting to test it with a different program, just to see if you get the same slow result on Windows Server 2003. ... "So the SQL server is NOT running on either the XP box or the 2003 box, ...
    (microsoft.public.vsnet.general)
  • Interesting Questions from 70-228(MS SQL Server 2000)
    ... stored on the SQL Server computer. ... and a 3-GB data file to drive F ... at a bank's headquarters. ...
    (microsoft.public.cert.exam.mcse)
  • Re: call to xp_cmdshell from trigger problem
    ... connecting to SQL Server using windows authentication. ... Logged on to the Windows server as the SQLProxy Account and connecting ... >> database and causes a trigger to fire and starts a process to notify the ...
    (microsoft.public.sqlserver.server)