Microsoft Access Database RSS

• • Reply
  

  mlaferriere

  0 Points

  8 Posts

  Microsoft Access Database

  Nov 06, 2012 07:44 PM|LINK

  Hi Folks - I'm using VS Express 2010. I have a .mdb file that I would like to use with my ASP site. Data traffic would be moderate, read-only. Is a .mdb file an acceptable choice? Or, should I go .sdf? If .sdf is a better solution, how do I export/import the data? Thanks.

  Michael

• • Reply
  

  Mikesdotnett...

  All-Star

  154927 Points

  19867 Posts

  Moderator

  MVP

  Re: Microsoft Access Database

  Nov 06, 2012 08:35 PM|LINK

  mlaferriere

  Data traffic would be moderate, read-only. Is a .mdb file an acceptable choice?

  Yes. Make use of caching as much as you can too.

  mlaferriere

  Or, should I go .sdf?

  My preference would be sdf as it runs in process so should theoretically provide better performance. And it supports a wider range of T-SQL than JET. I'm not sure if there are any tools that will aid migration from Access to Sql Server CE, The only SQL Server CE managment tool I'm aware of is this one: http://sqlcetoolbox.codeplex.com/

  Otherwise you can do it though code.

  Regards, Mike
  Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter
  • Marked as answer by Mikesdotnetting on Nov 08, 2012 05:03 AM
• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: Microsoft Access Database

  Nov 08, 2012 12:07 AM|LINK

  mlaferriere

  I have a .mdb file that I would like to use with my ASP site.

  My addition,

  This is an asp.net site instead of pure asp one, so if you have futher information of asp, I suggest you asking questions here for futher help.

  http://forums.iis.net/1044.aspx

  Here we talk about IIS and Classic ASP on official Microsoft's forum.