« Previous Next »

• 09-29-2009, 11:09 AM

  rkr31 Joined on 05-01-2007, 10:15 AM Posts 30

  access database with dfsr Reply Contact Hi  I have an IIS7 farm working without problems across multiple servers using shared config and DFSR but have been asked to support a classic asp site that uses a MS Access backend.  Is this supported in shared config?  How does the access database behave with locking and replication?  What happens if it is edited by two different instances across two different servers at the same time?  Will all data get written?   Thanks Richard

• 09-29-2009, 11:46 PM

  In reply to

  lextm Joined on 10-22-2008, 12:18 AM Shanghai, PRC Posts 1,423

  Re: access database with dfsr Reply Contact Richard, Access is not designed for the web, so I am really not sure what would happen if you deliver that application in this system. It may work well or it may break and report errors which are hard to diagnose. Can you talk to the developers of this application and suggest they upgrade it to use database products such as Microsoft SQL Server or another? Lex Li Support Engineer at Microsoft --------------------------- This posting is provided "AS IS" with no warranties, and confers no rights.

• 09-30-2009, 3:13 AM

  In reply to

  rkr31 Joined on 05-01-2007, 10:15 AM Posts 30	Re: access database with dfsr Reply Contact I would love to do that, but it is a legacy application that we have inherrited so i am sort of stuck with it.  Is that the official Microsoft line then?

• 09-30-2009, 3:16 AM

  In reply to

  lextm Joined on 10-22-2008, 12:18 AM Shanghai, PRC Posts 1,423	Re: access database with dfsr Reply Contact I had a blog post here (http://blogs.msdn.com/lexli/archive/2009/06/26/database-for-web-applications.aspx). There is a whitepaper on that topic but I am not sure if it is the official information you want. Lex Li Support Engineer at Microsoft --------------------------- This posting is provided "AS IS" with no warranties, and confers no rights.

• 09-30-2009, 9:47 PM

  In reply to

  steve schofield Joined on 06-10-2002, 4:54 PM MI Posts 3,966

  Re: access database with dfsr Reply Contact this could be converted to sql server by uploading the tables, changing the connection strings.  depends on how complicated I guess.  I'd persue that or have a separate site where the db / asp is on one server.  Access wouldn't work being on a shared drive, I guess it would work but anything beyond a couple users hitting it, things would crash. IMO Steve Schofield Windows Server MVP - IIS http://weblogs.asp.net/steveschofield http://www.IISLogs.com Log archival solution Install, Configure, Forget

• 10-18-2009, 3:47 AM

  In reply to

  stever@bitshop.com Joined on 04-18-2005, 9:15 PM Ashburn, VA Posts 13

  Re: access database with dfsr Reply Contact Most likely for what you will cost to recover the data once access crashes you could have paid a consultant to upsize it. The only exception would be if users are accessing this data via network share ALSO (as if 2 web servers isn't bad enough). Here's the options in order I'd do them: Upsize to sql use ARR / load balancer to take the urls that write to these files and hit 1 server with max load and the other with min (I don't recall the max/min number you can enter). Use one server for this url via dns - http://www-access.example.com instead of www.example.com Upsize to sql in most cases isn't more than a day's work, many times < an hour. We've done this hundreds of times for customers hosted here, although mostly 5+ years ago... Steve Radich - President BitShop.com - IIS Cloud Solution Coming Soon - Join our "Free 3 Month Beta" Waiting List Now...