Drew Wutka
DWUTKA at Marlow.com
Tue Jun 23 16:22:27 CDT 2009
Ah, but that's only one end of the connection! You'll need that kind of speed to where you are connecting too! We used to have a shotgunned T1 situation here at work (so we had 3Mb up and down), a month ago, we dropped down to just one T1. At home, I have 6Mb down, and 384k up, so my connection 'speed' through my VPN dropped in half. Having a faster connection at home won't do anything unless work gets a big boost too! Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Tuesday, June 23, 2009 3:35 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Learning .Net Hi Drew: I can hardly wait until fiber-opticale gigabyte internet lines starts coming down my street... as this will just be a moot point. ;-) Of course what ever works for you is just fine. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Tuesday, June 23, 2009 8:34 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Learning .Net Yes, remoting in, such as with Remote Desktop, or some other Terminal session, will work fine, because you are getting the screen, not working a file based database across the network. However, sometimes you just want an application running on your local system. For example, when I am home, I make a VPN connection, and open Outlook, so I almost always have my work email (the only email system I really use). I also have an application that used to be our request system. It has a lot more features, so it is still in use (even though we now use a very slow web based 'request' system). It has automatic links to various systems, and more importantly, it has a 'Phone List' for the company. That phone list is pretty tricked out. I can search for someone in a blink of an eye, and from that search, can get their contact info, if they are online, can remote into their machine, can use remote computer management, links to their local drives, etc. Can switch the phone list to list our online servers too. While I could remote in to use that app, I prefer to be able to use it straight through the VPN. When that app was .mdb based, it would take 20 to 30 times longer to do anything. Very sluggish. (And it did use ADO to access the .mdb). Now it hits a SQL server, and there is a fraction of a delay over a VPN versus when I am local. That is truly the only advantage I have found though, because this app ran just fine locally over our local network when it used an .mdb. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Monday, June 22, 2009 10:17 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Learning .Net Hi Drew: I have found the best solution is to remote-in rather than try to run an Access MDB through a VPN and if you are going to do the VPN then unbound with ADO-OLE works well for me. You can get a free express version of Oracle and forms app... I have no idea how good they are. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Monday, June 22, 2009 1:41 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Learning .Net Not Oracle? Yikes! <grin> As an ardent fan of Access (especially Access 97), I must admit that knowledge in a server side database can come in real handy! On a normal network, an .mdb solution works fine, but try using it over a VPN, and yikes..... Drew The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.