Are we being pushed away from Access db to ... (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

nettop -> Are we being pushed away from Access db to ... (2/24/2008 18:48:29)

I have been using Access databases and .asp pages for several years. Most of the time, things have worked well for me and my clients...especially with the help of this Forum and Spooky. However, I feel as though my web business is at a crossroads. The key to what I do is to create on-line databases for my clients to more effectively manage their businesses/associations. With the advent of Expression, VWD and .net and php/mysql, it appears to me that WE are being phased out of the web if we want to keep using Access/FPDB/DRW etc. I have been exploring each platform (Linux - php/mysql...big learning curve) & (Windows - SQL server 2005 or 2008/.net...expensive) and each has their pros/cons. My particular webhost wants to charge me $25 for each SQL database, where I currently don't pay anything additional each time I add a new Access database. Are any of you dealing with a similar issue? Do you have any suggestions on how to proceed forward to a stable, web database future? Thanks for your suggestions, Tim



Spooky -> RE: Are we being pushed away from Access db to ... (2/24/2008 23:45:37)

Normally you can get quite a few MySQL databases on a plan for the same price.
Asp interacts with that in more or less the same way as with SQL and Access.
So its not a case of any major changes just for changes sake.

It is a tough question though...



rdouglass -> RE: Are we being pushed away from Access db to ... (2/25/2008 9:28:32)

AFAIK the rules haven't changed for Access. You can still use them with .NET and ASP will still be supported for quite some time yet IMO.

I'm still doing Access DB's if it fits the task. My criteria for the database hasn't changed any just because I'm now working typically with .NET instead of Classic ASP. Small Db's still justify the use of Access to me. It should still come down to the requirements of the database and not the current opinion or developemnt tools.

But as Spooky said, mySQL is a good bang for the buck. Generally speaking if you can do something with MS SQL Server, you can do it in mySQL for a whole lot less. The syntax is very, very similar to MS's and it is very widely supported.

The only place I ever notice much of a difference is when I'm in Visual Studio (.NET) and building DAL code or classes.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875