Prev: Data Fields Changing
Next: Tables and relationships?
From: Al on 13 Jan 2010 13:25
We developed a SQL application with an Access front end. Works great in
central office but field offices can't log on. Field office can access server
and can pull up application but when they enter login name and password (part
of our application) Access doesn't do anything. Field offices have installed
application registry for ODBC connectivity... is there anything that I have
overlooked? There is no other security set up through Access, thanks Al
From: Clifford Bass via AccessMonster.com on 13 Jan 2010 20:22
Hi Al,

Company firewall preventing access to the database from the outside
maybe? Or is it doing something, but just taking forever due to slow WAN
speeds?

Clifford Bass

Al wrote:
>We developed a SQL application with an Access front end. Works great in
>central office but field offices can't log on. Field office can access server
>and can pull up application but when they enter login name and password (part
>of our application) Access doesn't do anything. Field offices have installed
>application registry for ODBC connectivity... is there anything that I have
>overlooked? There is no other security set up through Access, thanks Al

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201001/1

From: Armen Stein on 16 Jan 2010 20:03
On Thu, 14 Jan 2010 01:22:23 GMT, "Clifford Bass via
AccessMonster.com" <u48370(a)uwe> wrote:

> Company firewall preventing access to the database from the outside
>maybe? Or is it doing something, but just taking forever due to slow WAN
>speeds?

Also, are the remote users actually in the domain, like with a VPN? If
not, you will need to use SQL Server Authentication instead of Windows
authentication - are you?

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 | 
Pages: 1
Prev: Data Fields Changing
Next: Tables and relationships?