Jim Lawrence
accessd at shaw.ca
Tue Jun 23 17:16:41 CDT 2009
I am looking to the day when fiber optical cable is the standard and not the exception then upload and download speeds will be dramatically improved. Our local government has run a fiber-optic backbone across the province so passing any amount of data is simple. Worked for them as staff and finally as a contractor for over 20 years and I just love doing province wide on site work as remote connections are just as fast as the local LAN. ;-) 100GB equals about 10 seconds. At home, well... back to reality. 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 2:22 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Learning .Net 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. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com