Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 VS 2005 upgrading Access to SQL ... painlessly?

Author  Topic 

studio2005
Starting Member

1 Post

Posted - 2007-01-30 : 16:22:32
My environment is Visual Studio 2005, ASP.NET 2.0, MS Access and --soon -- to begin using SQL Express 2005. How could I create webpages in MS Access and avoid re-writing the UI's DataSource (Access) when I upgrade/export all my tables from Access to SQL 2005? Something to do with changing Connection strings? Any suggestions about doing this in one place so that if all the table and field names remained the same in SQL there could be a simple transfer? I sense the "pros" do this type of thing routinely, ... but I am not sure how to do that in my Visual Studio 2005. Please help! Thanks!

Chris
   

- Advertisement -