a bit of advise please



I am starting to work with ASP.NET but am finding so many options that I am
getting confused and would appreciate some advice.

I have developed several ACCESS databases that we use internally and ASP
pages to make some of the information available on our company website -
this works very well and I like the flexibility of both Access forms and ASP
web

Our site has low traffic with never more than 3 on at any time - mostly I
get information from the Access database as quick as possible and close it
straight away so tables are never left open for very long.

questions.
1/ Is there anything really wrong with using Access MDB files for
data-storage on a "small" site
2/ Should I move to SQL Server and if so can I still use Access to
manipulate the database
3/ For a small site does SQL Server offer anything more than SQL Server
Express
4 / if I do develop in ASP.NET with an Access MDB file, can I move the
database to SQL Server later on
5/ Does the Access Upsizing Wizard work with SQL Server Express - I tried
and failed, this maybe my mis-understanding
6/ Is "Visual Web Developer 2005 Express Edition" enough for my needs
("free" seems too good to be true)



My feeling is that Web Developer with Access should be enough for my needs
but I'd like a bit of reassurance/guidance.

Any feedback from users with more experience would be really appreciated

All the best
Phil


.



Relevant Pages

  • Available dotnet Consultants : 217-241-2015
    ... Microsoft Technologies and SQL Server 2005. ... Senior .NET Developer ... Server 2000, IIS, and Windows 2000. ...
    (microsoft.public.dotnet.languages.csharp)
  • ANN: San Diego .NET Technical Summit, May 21 2005, brought to you by SanDiegoDotNet.com
    ... Conference Date ... The San Diego Technical Summit will be held Saturday May ... SQL Server 2005 for Developers ... productivity enhancements for the database developer. ...
    (microsoft.public.dotnet.general)
  • Re: New SQL Book Scam or Not?
    ... Mike Epprecht, Microsoft SQL Server MVP ... Specialist SQL Server Solutions and Consulting ... >> If you are a SQL Server developer, a .NET developer, or a Development ...
    (microsoft.public.sqlserver.server)
  • .NET Programmers
    ... Microsoft .Net, SQL Server, business intelligence, full life ... Java Programmer, J2EE Developer, C# Developer, .Net Developer, VB.Net ...
    (comp.lang.javascript)
  • .Net Programmer Multiple Vacancies
    ... Microsoft .Net, SQL Server, business intelligence, full life ... Java Programmer, J2EE Developer, C# Developer, .Net Developer, VB.Net ...
    (comp.lang.java.programmer)

Quantcast