Home > IT Answers > Database > MS Access Networking
Ganzit
65 pts.
 MS Access Networking
Microsoft Access, TCP Ports, WAN
Which TCP port(s) can I use to monitor access database queries over the WAN?

Software/Hardware used:
ASKED: February 12, 2010  4:20 AM
UPDATED: February 12, 2010  10:17 PM
RELATED QUESTIONS
Answer Wiki:
Access isn't a client server application like a SQL Server or an Oracle database. All traffic from the Access application which is opened on the client computer to the machine which hold's the mdb file with the database will be sent over the standard SMB network ports which are TCP 135 and TCP 445. However there will be a lot of other traffic in there which as other network share traffic. If the machine with the file server is also a domain controller you'll have to deal with all the domain authentication traffic as well. It might be easier to setup some auditing within the access application instead.
Last Wiki Answer Submitted:  February 12, 2010  7:58 am  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thanks, Mrdenny! The network appliances that I use can capture packets along with RMON-like reporting capabilities. I’ll capture enough SMB traffic to get the server addresses and then configure the appliance to report traffic based on each URL. That way I can separate the database traffic from the “noise.”

I really appreciate your quick and knowledgeable response.

Ganzit
 65 pts.