Is it possible to use subsonic with MS access MDB files?
+3
A:
From the looks of things, no. http://forums.subsonicproject.com/forums/t/2968.aspx Looks like an 'offline beta' was created, but looking at the thread there, looks like things ran into problems. Access really is a different animal (it's a faux-db, for goodness sakes), so anyone willing to write a DAL like Subsonic would be targeting the real deal, like Oracle, MySQL, and MS SQL. Any reason why you aren't at least using one of the Express Editions of MS SQL Server? You'll certainly get more mileage, scalibility, and compatible tools by going that road.
Wayne Hartman
2009-05-15 00:46:11
-1 for badmouthing Access unnecessarily.
David-W-Fenton
2009-05-15 23:38:01
Yeh, until recent versions, it supported more SQL features a complex queries than MySql. It might be file based rather than server based, and it might crash a lot with lots of concurrent users, but it's very much a real SQL database.
U62
2009-06-05 12:06:42
+1 since, while the Access bashing exists, the answer is valid with follow up resources to the subsonic forums.
JamesEggers
2009-06-10 11:55:54
-1 for badmouthing Access +2 for the right answer ;D
Oorang
2009-06-18 03:09:13