what is a SQL server how do I get one

[ida]

I am trying to start a new project. I am asked for an SQL server but I hve
no idea what that is or how to get on.

 

[boblarson]

Check this out here:
http://www.microsoft.com/sql/howtobuy/default.mspx

--
Bob Larson
Access World Forums Administrator

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[Klatuu]

You can download the express edition free:
http://www.microsoft.com/sql/editions/express/default.mspx

But, if you don't know how to use it, you have a pretty steep learning curve.
Is there any reason you need to use it instead of native Access tables?

 

[Dev]

I am a new user to Access. I purchased a book from Microsoft to learn how to
use Access. When I try to start a new project using new data, I am prompted
to supply information about the SQL server connection. I saw the
correspondence below on your site which is great, but it does not instruct
how to use Access natively. How do you creat native Access tables?

Dev

 

[Klatuu]

It sounds like you selected New Project. That would not be correct to use
Access in its native mode. a Project is an adp file (if you are using 2003).
You want to create a new database. Then from the Tables pane of the
database window, click on new. You will now be able to create a table.

 

[Dev]

Dave,
Thanks for writing back, but not sure that helped. Everything I click on
seems to open up a window with "File New Database" at the showing me the
directories on my computers and "adp1" as a file name.

I looked in the book, but cannot seem to find how to ge to the Tables pane
of the database window.

Also, I have Excel spreadsheets from which I want to import the data. Once
I create the new database, will I be able to import the data from Excel?

Thanks! You rock!
Dev

 

[Klatuu]

You are not understanding what I am telling you.
You are using the wrong kind of Acess file.
When you open Access, instead of selecting New Project, select New Database.
They are two different formats. adp files are only used for connecting to
SQL databases. You want to create an mdb file.

 

[Dev]

It's not my ability to understand that was the problem. Your note was not
very clear.

Thanks for writing back.

 

[Klatuu]

Rereading my original reply, I can see where it may not have been explicit
enough.
Do you now understand, or do you need additional help?

 

[Dev]

with your additional notes and clarification, I was able to understand.
Thanks for the help.
Dev