Hello...I have one big problem with this kit: my hoster doesn't provide a MS SQL database support so i can't even try this example. It is possible to convert SQL Server database (mdf) to MS Access database (mdb)??
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.
Laserson
0 Points
7 Posts
MS SQL Server 2005 to MS Access
Aug 03, 2007 05:00 PM|LINK
Hello...I have one big problem with this kit: my hoster doesn't provide a MS SQL database support so i can't even try this example. It is possible to convert SQL Server database (mdf) to MS Access database (mdb)??
Mikesdotnett...
All-Star
155593 Points
19979 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.
Web Pages CMS | My Site | Twitter