N
news.microsoft.com
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
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