Editing Access Front End

[hmhill17]

I have two Access front ends for SQL Server 2000 written a million years ago. They have been running on Server 2000 Terminal Server with an Access 2000 runtime for TS. I now need to move them to Windows 2008 and SQL 2008. I moved them both to Windows 7 64bit with a minimum of difficulty. When I moved them to Server 2008, I got the same error messages. The fixes that worked in 7 didn't work in 2008. Here are my problems:

Environments:
Windows 7 64bit
SQL 2008 SP1
Access 2003 RT or Access 2003 (Access 2010 blows up)

Windows 2008 R2 64bit
SQL 2008 on separate server
Access 2003 RT

Front end 1 gets an ODBC error. A separate copy gets a you do not have permissions to access error. Saw both of these errors on 7 but some minor changes on SQL Server made them go

Front end 2 just hangs completely on 2008. On 7, it gives me the following error. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. It does open and appear to work after I hit OK.

My best theory is that there's something in the front end I need to edit. However, if I open the front end, all I get is the application and nothing that will let me alter the forms. I also tried the hold down shift and open that I saw elsewhere on the site. Same thing. Any help woudl be appreciated.

 

[hmhill17]

Figured out the problems.

There's a 32bit ODBC in the SYSWOW64 folder. Had to put the ODBC there.

There was a connection string pointing to a name that some genius had in the Hosts file instead of using machine name or IP. That caused the DBNETLIB error.

 

[Pat Hartman]

Thanks for posting back the resolution and welcome aboard