Need Your Thoughts

I currently have an Access application that I have been working with for a
couple of years now, it is growing in size rapidly. I am thinking that I
need to be planning to take it to the next level.
Is SQL Server an appropriate thought?
Never have dealt with it before, but I have been reading a little about it.
I kinda like the thought of how it deals with records rather than Jet.
Is it appropriate to think about a web based interface to share the database
or is that thought total wrong?
I think this will be a new learning curve for me but thats alright, I thrive
on challenges.
If someone could take a few moments and en-lighten me with their thoughts it
would greatly be appriciated.
Thanks
David WI would pick Microsoft SQL Server over MSAccess any day of the w. I
can't think of any situation where I would prefer to use MSAccess. SQL
Server is a proper multi-user RDBMS (relational database management
system). It was designed like that from the ground up. Using a web
server as a front end to a SQL database is very common. There would be
literally millions of applications that do this. Companies like Barnes
& Noble (http://www.barnesandnoble.com/), Home Shopping Network
(http://www.hsn.com/) & Radio Shack (http://www.radioshack.com/) all do
this exact thing.
*mike hodgson*
http://sqlnerd.blogspot.com
David W wrote:

>I currently have an Access application that I have been working with for a
>couple of years now, it is growing in size rapidly. I am thinking that I
>need to be planning to take it to the next level.
>Is SQL Server an appropriate thought?
>Never have dealt with it before, but I have been reading a little about it.
>I kinda like the thought of how it deals with records rather than Jet.
>Is it appropriate to think about a web based interface to share the databas
e
>or is that thought total wrong?
>I think this will be a new learning curve for me but thats alright, I thriv
e
>on challenges.
>If someone could take a few moments and en-lighten me with their thoughts i
t
>would greatly be appriciated.
>Thanks
>David W
>
>|||>> I currently have an Access application that I have been working with for
a couple of years now, it is growing in size rapidly. <<
LOL!!n Welcome to developer and DBA hell! ACCESS sucks and does not
scale.
Good and probably true if the app is any good.
Yes, or another SQL product, depending on other issues.
It will be a lot of UN-learning.