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.
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.