Wednesday, September 06, 2006
SQL Server 2005 and Access 2003
Our flagship app, ParaPlan, has been running on SQL 2000 for over 2 years now. Before we re-design everything in .NET, I wanted to see if I could get it to work with SQL 2005 (as is). My attempts thus far have led to the following: 05 has many more INFORMATION tables and SYS tables associated with each database. I have MUCH MUCH more to learn, but I know that I could get an 05 SQL db attached to an Access front end, but I am having trouble with permissions (to the best of my knowledge). So as I learn more and/or hear from someone, stay tuned.