Drew Wutka
DWUTKA at Marlow.com
Thu Jan 21 18:14:32 CST 2010
Worked on my end. I hope it works on yours! Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Thursday, January 21, 2010 4:44 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Windows 7 64 bit Thanks! Hope it works ... Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Thursday, January 21, 2010 4:29 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Windows 7 64 bit Yes. That's called split tunneling. Split tunneling is where a VPN connection allows one networks traffic to travel through the VPN tunnel, and the rest through the user's gateway. Companies (like mine) will usually setup a NO split tunneling policy, because split tunneling is a security hole (though a pretty rough one to get through). The Shrew VPN client does let you get around the split tunneling policy, at least it did for our network. To do this, you have to go to the last tab in the properties of the connection you import from the .pcf file. That last tab is 'Policy'. There is an option saying something about network topology and tunneling. It will be checked. Uncheck it. Now the fun part. Once unchecked, you now have to tell the VPN client what traffic needs to go through the VPN tunnel. There is an add option. So let's say the network you are going to is 192.168.0.0 through 192.168.0.255 (a small network). You would click add, it should default the item to Include (which means it will include that traffic in what goes through the tunnel), then you would put in 192.168.0.0 for the IP address and 255.255.255.0 for the subnet mask. And that would do it. A larger network requires a larger subnet mask. So you need to know what the IP addresses are for the network you are connecting too, and their range. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Wednesday, January 20, 2010 3:57 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Windows 7 64 bit Hi Drew, Thanks for the info about the VPN call Shrew. I also use Cisco VPN with one client, and would like to upgrade to W7 64. When I use Cisco, it completely blocks all my internet access (unlike two other VPN clients I have). Does Shrew allow internet access while it's connected? Thanks! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Wednesday, January 20, 2010 3:42 PM To: Access Developers discussion and problem solving Subject: [AccessD] Windows 7 64 bit There's been some talk about Windows 7 on here, and since it going to be hitting your user base, I figured I would share some 64 bit info. I've been running 64 bit on my work desktop for about 2 years now. (Vista until October when 7 was actually released). I've now been running 64 bit on my laptop for the last 3 months. >From our user's standpoint, there were two issues that we had with 64 bit. Oracle ODBC connections, and our Cisco VPN. Everything else we install on a typical machine works just fine on a 64 bit box. There are some 'admin' things that don't work in 64 bit, but I don't care much about that, cause I use Virtual PC like it's my right arm, so I just have that stuff in a VPC environment. The Oracle thing was a show stopper though. Our production database (Glovia) is running in an Oracle database. It used to be a Unix box, but is now on a Window's based rack server. The application for our production database works just fine in a 64 bit environment, and doesn't use an ODBC connection. However, long before I got here, they were using Access as a 'report engine' for Glovia. So there are a handful of these databases that need to connect to Oracle through an ODBC connection, for all these reports to work. Problem #1. Oracle doesn't make a 64 bit ODBC driver. They do however have ODAC101040.exe which is an ODBC driver for Oracle 10g. When trying to install this several 'unknown' errors come up, and the install fails. However, you can right click on it and select Troubleshoot Compatibility, this then goes and let's you run the install without a hitch. Once that is done, the next trick is that the ODBC manager in the control panel is a 64 bit manager. To use the 32bit manager, you have to go to C:\Windows\SysWOW64\odbcad32.exe . Looks the same, but this will then let you setup your ODBC connection. Now, I got this part done months ago, but ran into the next problem. Problem #2. I could 'test' the connection from the 32 bit ODBC connection manager, successfully, but whenever I tried to use the ODBC connection from Access, I would get 'ODBC Error'. Sigh. Well a few weeks ago, an order was placed for a laptop for one of our accounting people that I wanted to setup with a very decent laptop. It came in last week, but I was hesitant to put Windows 7 64 bit on it, because she uses these ODBC tables all day long, and I didn't want to force her to use a Remote Desktop session to a machine that had everything working...so I dug into some more research, and guess what....the problem was in WHERE Access was installed too. On a 64 bit machine, 32 bit programs get installed (by default) to C:\Program Files (x86)\ and those parenthesis' were tripping a bug in Oracle, cause apparently whatever app tries to connect to the ODBC connection is sending along it's full application path. On my own desktop, by just moving msaccess.exe to the root of one of my drives, the ODBC stuff started working right away! Go figure! The other 64 bit issue was the Cisco VPN client. Apparently Cisco refuses to make it's standard VPN client compatible with 64 bit technology (which is weird, because Cisco is supposed to be so 'cutting edge'...LOL). So I found http://www.shrew.net/home a FREE 3rd party app that let's you use Cisco .pcf files for configurations, and it connects like a charm! Woohoo. 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 -- 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.