Last post Aug 03, 2007 01:25 PM by Mikesdotnetting
Aug 03, 2007 01:00 PM|Laserson|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)??
Aug 03, 2007 01:25 PM|Mikesdotnetting|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.