what is a SQL server how do I get one

  • Thread starter Thread starter ida
  • Start date Start date
I

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.
 
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
 
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.
 
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
 
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.
 
It's not my ability to understand that was the problem. Your note was not
very clear.

Thanks for writing back.
 
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?
 
with your additional notes and clarification, I was able to understand.
Thanks for the help.
Dev
 
Back
Top