Recent content by tom in houston

Hi: I'm missing the big flick somewhere... hope somebody can clue me in. I have a local table in MSAccess that holds temporary data. The point of the temp table is to allow the user to scrub up the data and change a couple field values that vary by record before committing the data to the...

Lightwave - will look at the website when I get back to my computer - thanks for the suggestion

(very) small business - no server, just a couple desktops. part of the allure of moving to a hosted service was to let somebody else deal with all the IT issues. So much for that plan!

sorry - I wan't real clear in my initial post... 3rd party hosting service. Tried contacting them - they tried to be helpful, but the guy I spoke to had zero experience with Access and basically couldn't help me at all. Additional info - dropped all linked tables and shifted over to pass thru...

I am an absolute newb on configuring connections, so be gentle... However, I found MS Mr. Fit It for disabling IPV6 (kb 929852) and followed it. No improvement. Since the SQL Server is hosted by a 3rd party, I don't think I can accomplish the rest of your suggestion. Any other ideas?

OS for SQL: Microsoft Windows Server 2008 R2 OS for Access Box: both are win7 64 bit Can you clarify if you were running 32 or 64 bit in your cited example... In other words if I have this problem, should I expect it would affect all 64 bit client OSs, or only some. Thanks!

Hi: I'm having trouble with linked tables. Basic Setup - Access2010 connecting to a shared SQL SERVER 2005 (provided via databasemart). Access FE has linked tables to SQL Server tables. DSN-less connection using the following string: strODBC = "ODBC;DRIVER=SQL Server;SERVER=" & strServer &...