I have an ms access 2013 web database on office 365.
I created a reporting ms access database and build reports for distribution to client PC.
the database works fine for computers that are not inside the my client's local area network but gives connection failed when connecting using the computers inside the LAN. Please note the computers have connection to the internet and the users are already using then web app on office 365. I have also installed the SQL Native Client driver 11.0 as i have done on the my dev machine which works fine.
I have also enabled connecting to the database from any location on the internet.
Is there perhaps a firewall setting somewhere that is stopping these computer to connect to the SQL Azure database that I need to change. Please help.....
I created a reporting ms access database and build reports for distribution to client PC.
the database works fine for computers that are not inside the my client's local area network but gives connection failed when connecting using the computers inside the LAN. Please note the computers have connection to the internet and the users are already using then web app on office 365. I have also installed the SQL Native Client driver 11.0 as i have done on the my dev machine which works fine.
I have also enabled connecting to the database from any location on the internet.
Is there perhaps a firewall setting somewhere that is stopping these computer to connect to the SQL Azure database that I need to change. Please help.....