Good morning, we are running SQL server on a stand alone PC, which we access on the front end with Access 2013 Enterprise 3.  we then connect to that stand alone PC from other computers to interrogate the database.  We get OBDC conflicts (not allowing such remote pc's to connect to the database pc) the minute we switch the firewall on.

Does anybody have a way around this apart from turning the firewall off?

Thanks

Your firewall is blocking that's why when you trun off wirefall it works fine.

Check this to fix:

http://www.completesoftware.net/2014/01/odbc-connection-and-your-microsoft-windows-firewall/