[AccessD] Learning .Net

Drew Wutka DWUTKA at Marlow.com
Tue Jun 23 10:33:51 CDT 2009


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.





More information about the AccessD mailing list