P
Patrick@countrywide
Need to know what port to open on firewall to allow connection to Access
databases. In other words what port does access use?
databases. In other words what port does access use?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Albert D.Kallal
ms-access is a file share, and is simply part of Microsoft office.
So, in effect, you question is:
what port do I need to open to work with Word
what port do I need to open to work with Excel
what port do I need to open to work with a pdf file
So, whatever port on the network that allows you to open a word file, or pdf
file, or in fact ANY file is the port you need to open.
Do note, that in addition to opening the correct ports, you must also use a
network protocol. What this typically means is that you also have to setup a
network connection between the two computers. Thus, if you got two computers
on the internet, then you have provide a file open, or "connection" ability.
This typical means a VPN.
So, in fact, you need to provide the SAME ability as the standard windows
browse to a folder. If you can browse to the folder across the network, then
you can open the ms-access file. If those tc/ip ports are closed, the you
can't connect. However, do note that the ports you are talking about have
nothing to do with ms-access, but only that of allowing you full rights and
the ability to access and browse files in that shared folder. So, those
ports, and rights are no more special to opening a pdf file, a excel file,
or in this case a ms-access file. We are talking about a regular plain
windows file. You are just opening that file, and if a network is involved,
then Excel, or ms-access does not care, or know about some ports. So, the
only ports that need to be open are the same ones that allow windows network
(usually tc/ip, but could be net-bios etc) to function. This is strictly a
OS issues, and not one of pdf files, or excel files, or in your case
ms-access. Regardless, a file is a file is a file...
It is also not clear what kind of network you are taking about here.
Generally, for multi user use of ms-access, you need to split your
application into two parts:
The front end part goes on each pc, and is the application part
The back end part is a simply mdb file in a shared folder, but only contains
data...not forms and code.
Do be aware that a high speed internet connection is 100 times slower then
your typical office LAN, and as result a file share does NOT work across
this type of connection very well at all. You can read up on why, and some
solutions here:
http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html
So, in effect, you question is:
what port do I need to open to work with Word
what port do I need to open to work with Excel
what port do I need to open to work with a pdf file
So, whatever port on the network that allows you to open a word file, or pdf
file, or in fact ANY file is the port you need to open.
Do note, that in addition to opening the correct ports, you must also use a
network protocol. What this typically means is that you also have to setup a
network connection between the two computers. Thus, if you got two computers
on the internet, then you have provide a file open, or "connection" ability.
This typical means a VPN.
So, in fact, you need to provide the SAME ability as the standard windows
browse to a folder. If you can browse to the folder across the network, then
you can open the ms-access file. If those tc/ip ports are closed, the you
can't connect. However, do note that the ports you are talking about have
nothing to do with ms-access, but only that of allowing you full rights and
the ability to access and browse files in that shared folder. So, those
ports, and rights are no more special to opening a pdf file, a excel file,
or in this case a ms-access file. We are talking about a regular plain
windows file. You are just opening that file, and if a network is involved,
then Excel, or ms-access does not care, or know about some ports. So, the
only ports that need to be open are the same ones that allow windows network
(usually tc/ip, but could be net-bios etc) to function. This is strictly a
OS issues, and not one of pdf files, or excel files, or in your case
ms-access. Regardless, a file is a file is a file...
It is also not clear what kind of network you are taking about here.
Generally, for multi user use of ms-access, you need to split your
application into two parts:
The front end part goes on each pc, and is the application part
The back end part is a simply mdb file in a shared folder, but only contains
data...not forms and code.
Do be aware that a high speed internet connection is 100 times slower then
your typical office LAN, and as result a file share does NOT work across
this type of connection very well at all. You can read up on why, and some
solutions here:
http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html