jwcolby
jwcolby at colbyconsulting.com
Sun Jan 16 21:21:26 CST 2011
Today I stepped back and set it all up internal to my network. Yesterday I had moved the Fe to my laptop. Today I deleted all of my linked tables, then I relinked all of the tables. In doing so I created a new DSN where I hit the SQL Server directly at the Hamachi IP address. Relinked using this new DSN and voila, she's a wurkin, and lightning fast over my internal network but forcing the traffic through Hamachi. So I tested a bit, then went back out to the local Arby's where I was pretty much unable to do anything last night (other than browse the internet). Got right on the connection, opened the Access FE and voila, she's a wurkin, and lightning fast. You wouldn't know you weren't directly on my LAN. Access on my laptop over Hamachi, over a public network, in to my network, directly into a Virtual Machine over Hamachi, running SQL Server 2008 Express. I am so jazzed! that leaves me with one technical barrier now, getting an Access 2007 run-time to host an Access 2003 FE. Now I need to set up a VM to run on my laptop so that I can have an environment without Office installed. Install the Access 2007 run-time and drop the Access 2003 Fe in place. Set up Hamachi on that VM and then get it all playing nice. This will allow me to take my laptop on the road to demo the system. We shall see. And yes Jim, I understand I still need to cause SQL Server to do the heavy lifting. To this point I have never really used SQL Server as the BE for Access. My biggest client uses Access 2K and it doesn't really play nice with ADO. Since I can now develop these new databases in 2003, I can do things like bind the form to an ADO recordset and still have it read/write. I will need to learn how to use a stored procedure were I can pass in a PK and have the SP return a table of data already selected and sorted. I.e. SQL Server doing the lifting. The nice thing is that these are small databases so I can do things like leave the list tables just linked, at least for awhile while I learn all the stuff I have never had to do. Next up, 2007 run-time. -- John W. Colby www.ColbyConsulting.com