Wednesday, March 21, 2012

Help New to SQL server

Im working for a company that has a relatively small database but will continue growing. We would like to use SQL server to accomodate the mass users who will be accessing the data. I have never used sql server and would like to know where to get started. IE. books, websites(besides this one), prices. what will i need to get this database up and running?? I would like to have sql server as my backend and microsoft access as my frontend. any help would be greatly appriciated.

thanxhttp://www.sqlteam.com/store.asp

I would rethink Access as a front end...but that's just me...

Have you seen how much sql server costs?

You might want to look into MSDE...

How many users?

How much data are you talking about...

Is it internal to one office?

What is the application meant to do?|||Originally posted by Brett Kaiser
http://www.sqlteam.com/store.asp

I would rethink Access as a front end...but that's just me...

Have you seen how much sql server costs?

You might want to look into MSDE...

How many users?

How much data are you talking about...

Is it internal to one office?

What is the application meant to do?

-------------

Why would you rethink Access?? What else would you use as a frontend?

Cost is not an issue. How mush is it?

What is MSDE (microsoft developer edition??)

mmm possibly 200 users accessing from the web and 6 users from the office.

The data right now is about 40mb. I know this isnt alot. i could create the database in access then when necessary move it to SQL server, but access cant handle the amount of users i need.

The database will keep track of all billings, customer info, shipping infosql

No comments:

Post a Comment