New db?

I am going to design a new db that will be accessed thru web pages on my
intranet and the internet. Currently I am using a MS Access db and I have
been told that this is not the best, most efficient "core" for a db. Will
the "Express" edition of MS SQL give me what I am looking for or do I need
to look at the Workgroup Edition? I want to make sure that what ever I use,
it will be robust enough to handle growth.
Hello,
Express edition has a limitation 4 GB database size, So it may not be a good
oprion for you. COnsidering the features available in SQL Server standard
edition
I will recommend you for standard edition over workgroup edition. Take a
look into the below URL:-
http://www.sqlservercentral.com/columnists/bknight/comparisonofsqlserver2005editions.asp
Thanks
Hari
"Jeff Klein" <jklein@.nospam> wrote in message
news:%232IHD9jRHHA.3592@.TK2MSFTNGP06.phx.gbl...
>I am going to design a new db that will be accessed thru web pages on my
>intranet and the internet. Currently I am using a MS Access db and I have
>been told that this is not the best, most efficient "core" for a db. Will
>the "Express" edition of MS SQL give me what I am looking for or do I need
>to look at the Workgroup Edition? I want to make sure that what ever I
>use, it will be robust enough to handle growth.
>
|||Since you're coming from Access/JET, SQL Server Express would be the best
first step. Yes, it has a 4GB database limit but unless you're storing BLOBs
in the database, this would be more than enough for a seriously large
database. Yes, there are features in the Workgroup and Standard that might
prove useful (eventually), but (again), given that you're coming from JET, I
don't expect you'll need them.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Jeff Klein" <jklein@.nospam> wrote in message
news:%232IHD9jRHHA.3592@.TK2MSFTNGP06.phx.gbl...
>I am going to design a new db that will be accessed thru web pages on my
>intranet and the internet. Currently I am using a MS Access db and I have
>been told that this is not the best, most efficient "core" for a db. Will
>the "Express" edition of MS SQL give me what I am looking for or do I need
>to look at the Workgroup Edition? I want to make sure that what ever I
>use, it will be robust enough to handle growth.
>

New Database

I want to design a new database. When I right-click on 'Data Connections' in the Database Explorer from VB I notice that the 'Create New SQL Server Database...' is greyed out, so I can't create a new database.

What is going wrong here, please help.

It could be that your login account does not have permissions to create new databases on the server.|||

Thanks, but I found out that I can create it in an other way;

- name a new application and add a SQL Database from the templates.

But in the menu, that appears after right-click on "Data Connections' in the Database Explorer in VB the 'Create New SQL Server Database...' is still greyed out, that I don't understand why this is.

I am the only user of the computer, so I think I would have permission to create a new database, or not?

I have set the user instances in SQL Server on enabled with;

exec sp_configure 'user instances enabled',1 and reconfigure

Must I still do something else?