Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

remote Access

Status
Not open for further replies.

TRYP

Programmer
Jun 20, 2000
136
US
I got an Access front end and an Access Back end.
Any pointers on what to do to have the front end on a lap-top (mobile) and allow access (securly) to the server remotely ??

tryp
 
Try Invisible Admin security

Access asks users for a logon password only if a password is on the default Admin account. IF Admin does not have a password, all users log on as Admin by default with no password prompt, even if other users in the workgroup have passwords. You can use this to setup invisible security.

Develop your db in a secure workgroup by loging on as the user that owns all the objects. Assign the restricted permissions you want everyone else to have to the Admin user then remove the Admin user's password. You'll then have invisible secuirty that works no matter which workgroup a user is part of, even the standard default system.mdw

To get beyond the secuirty you must set up a shortcut to Access with the commandline option /user and /pwd. This will force the logon screen to come up. Then, knowing your developer level userID & password you can gain full access.

This is a great way to have a database set up for mutliple users across the LAN/WAN or remote sites via modem without having to administer a million passwords.

Hope this helps

Peter
 
TYRP -

Contact your LAN administrator and see if he/she has a VPN solution (Virtual Private Networking). This allows your remote user to use any ISP to connect to the internet, and make a secure connection back to your servers. Mostly, they are sold as an add-on to your firewall software (Cisco, Borderware, etc).

Chip H.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top