SQL server noob...

[fossy]

ok. I work with Access 2007 pretty good (not an expert, but pretty good). Now
I need to learn SQL Server 05 so I can pull tables and make some reports...
would it be possible to use OBDC to pull the tables into Access and to work
with them and create the queries and reports... Or, does SQL server has its
own GUI to create the reporst that (which i would need to learn). And if I
need to learn SQL Server, where would you recomend to star...

Thanks you.

 

[Jeff Boyce]

One of Access' strengths is its ability to link to data tables in Excel, CSV
files, Oracle, DB2, FoxPro, dBase, ... oh yeah, and SQL-Server, among many
sources.

You don't need to learn SQL-Server's "Reporting Services" unless you wish
to.

You will not find that SQL-Server offers a GUI you can adapt for your users'
interactions. Access does.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Bill Mosca]

Yes, you can link to tables an SQL database just like an access database,
but you use ODBC. Click on External data tab>More>ODBC Database. Select the
Link option and follow the wizard.

 

[Ryan]

You can use SQL Server as your backend, and access are your front end with an
ODBC Connection. You can find the ODBC Connection wizard tool in
C:\WINDOWS\system32 if you are using windows xp. Once you open the ODBC Data
Source Administrator, go to the System DNS tab, and click Add. Scoll to the
very bottom of available sources and you should see SQL Server
--
Please remember to mark this post as answered if this solves your problem.
Here is your setup
Name:Whatever you want the name to be
Description:Optional, if you want to describe the connection
Server: Use the dropdown to find the Server that SQL Server is running on.
Find out who runs the SQL Server and ask them if you have a login or if you
can use windows Authentication.
Select the defualt database that has the tables you want to access.
Your finished with your ODBC Connection.

Next you would open a blank Access Database. Then you would right click in
the tables section, and select Link Tables. In the bottom of the Link dialog
box, you would select from the dropdown ODBC Databases. In the Select Data
Source Dialog box you would click the Machine Data Source Tab, and then you
would see the ODBC Connection Name that you created earlier. Once you select
that connection, another dialog box will show up with all the tables in SQL.
Select the ones you want and then you will be able to query till your hearts
content. Hope this helps.

 

[Evan Camilleri]

Make sure that in SQL2005 test the fields you want to use prior to using
them in Access front end report writer.
For example type bigint in SQL2005 is not supported in Access