Access 97 vs SQL Server 6.5
I am not an expert here, but I think that you'll only see the advantages of
SQL Server when you get the data over a network, use stored procedures,
and/or have different users using the same data. If someone knows better,
I'd like to hear.
Ben
Quote:
> I have a SQL Server 6.5 running under Windows NT. When I read a table
> with 6000 rows SQL Server is very slow if it's compared with 6000 rows
> read in Access 97 under Windows 95 (the table is the same in both). I
> thought that the power and velocity of SQL Server would be bigger than
> Access, but the results don't confirm it.
> Can anybody explain the reason of this ?
> Thanks.
