jwcolby
jwcolby at colbyconsulting.com
Tue Jun 23 15:56:17 CDT 2009
> I can hardly wait until fiber-opticale gigabyte internet lines starts coming down my street... as this will just be a moot point. ;-) lol... I lost power the other day for hours on end. While my generator fired up and I went on with my work, I had to switch tasks to work local as my internet connection went out with the power. And NOT at my house, it was out all over town. This is one argument AGAINST cloud computing (and storage). John W. Colby www.ColbyConsulting.com Jim Lawrence wrote: > 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. > >