It's not easy to migrate this particular kit over to Access, as it relies on stored procedures, which Access doesn't support. That means you would have to re-write the DAL at the very least. You can replicate the basic stored procs as saved queries, but
anything that returns a value, or contains any type of control of flow code (such as if... else or Case ) or Sql Server specific functions like CHAR or CAST will need to be redone entirely
I'm not aware of anything that would automate the database conversion process from SQL Server to Access, so you would probably have to build your Access db from scratch too.
Mikesdotnett...
All-Star
154957 Points
19873 Posts
Moderator
MVP
Re: MS SQL Server 2005 to MS Access
Aug 03, 2007 05:25 PM|LINK
It's not easy to migrate this particular kit over to Access, as it relies on stored procedures, which Access doesn't support. That means you would have to re-write the DAL at the very least. You can replicate the basic stored procs as saved queries, but anything that returns a value, or contains any type of control of flow code (such as if... else or Case ) or Sql Server specific functions like CHAR or CAST will need to be redone entirely
I'm not aware of anything that would automate the database conversion process from SQL Server to Access, so you would probably have to build your Access db from scratch too.
Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter