Linking users of Access 2003 to SQL Server 2008 database
Access 2003, SQL Server 2008, SQL Server database, SQL Server Management, SQL Server Migration Assistant
We plan to go to SQL Server 2008. We need to link our Microsoft Access 2003 users to the databases created in SQL Server 2008. Will we be able to do this considering ODBCAD32 is what we use, and the databases we create will now be 64-bit?
Software/Hardware used:
Software/Hardware used:
ASKED:
June 28, 2010 8:03 PM
UPDATED:
June 28, 2010 9:22 PM
RELATED QUESTIONS
- 32 and 64 Bit SQL 2005 on Same Server
- SQL Authenticated user change his/her own password
- SQl Server 2008 standard Mirror architecture, fail over without changes in applications
- Synchronization of Windows Server 2008 Active Directory Users from a Sql Server table
- How to move sql server clustered instance to a separate stand alone server
Answer Wiki:
Yes you can use a 32bit driver to connect to a 64bit SQL Server.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
