|
|
Posted by Trevor Best on 10/02/25 11:33
Ol!v!é wrote:
> Also, I believe that Access can only work with 25 connections at most,
> while SQL Server can have virtually unlimited connections. Please
> correct me when I'm wrong.
That would depend on how well/badly the Access application was written,
the topology used (monolithic MDB, split Code/tables, unbound forms,
etc). YMMV a lot.
To the OP:
SQL Server will handle more users and support larger databases, both in
the physical limits and practical limits, has better security, is much
more robust and AFAIK doesn't lose pointers to text (memo) columns like
Jet does :-)
Navigation:
[Reply to this message]
|