Rx_
Nothing In Moderation
- Local time
- Today, 08:23
- Joined
- Oct 22, 2009
- Messages
- 2,803
Should this package be installed on my Windows 7 development workstation AND on the distribution Windows Server? Has anyone tried this?
The concern is that the Access 2007 Front-End linked tables using ODBC or DNS-Less connection on the Windows 7 Development Workstation will work the same when the Front-End is moved over to the distribution Windows Server.
Access 2010 with a Front-End connected to a Back-end via linked tables.
Used the Microsoft SQL Server Migration Assistant to migrate the Access 2010 Back-End to SQL Server 2008 R2.
Distribution of the Front-End uses Citrix. This means that Access 2010 front-end will be installed on a Windows Server to run. Access 2010 is not installed on each of the client's workstations.
Microsoft® SQL Server® 2008 R2 Feature Pack
http://www.microsoft.com/download/en/details.aspx?id=16978
Contains: Microsoft® SQL Server® 2008 R2 Native Client
The concern is that the Access 2007 Front-End linked tables using ODBC or DNS-Less connection on the Windows 7 Development Workstation will work the same when the Front-End is moved over to the distribution Windows Server.
Access 2010 with a Front-End connected to a Back-end via linked tables.
Used the Microsoft SQL Server Migration Assistant to migrate the Access 2010 Back-End to SQL Server 2008 R2.
Distribution of the Front-End uses Citrix. This means that Access 2010 front-end will be installed on a Windows Server to run. Access 2010 is not installed on each of the client's workstations.
Microsoft® SQL Server® 2008 R2 Feature Pack
http://www.microsoft.com/download/en/details.aspx?id=16978
Contains: Microsoft® SQL Server® 2008 R2 Native Client