MS Access Networking

65 pts.
Tags:
Microsoft Access
TCP Ports
WAN
Which TCP port(s) can I use to monitor access database queries over the WAN?
Asked: Last updated:
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Ganzit
    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.
    65 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: