Access Log in

[Al]

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

 

[Armen Stein]

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