Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
When no network and no server and single user then Access (JET) is often significantly faster than sql server. SQL server forces you to do everything though a huge extra layer that involves transactions and a socket based (network) connection. Jet just literally scraps data right off the disk with no huge framework between that reading of data from the disk. SQL server or Access (JET) does not change the speed of file reading from the disk drive. So, JET has significant less overhead then sql server and my testing shows JET is often 50% faster when no network is involved
|Access 2013 - assign the value of an unbounded object to a table value||8||27|
|Is there a better way to combine two queries||7||27|
|Microaoft Access on a SBS 2011 Server||4||18|
|MS SQL AND PASSING A TABLE NAME TO A SPROC||5||18|