Access Reports with SQL Server database

[Gumby]

I am trying to create reports in Access application but all the tables are in SQL Server database. So can anybody tell me how can I connect Access application to the SQL Server database?

Any help would be greatly appreciated.


Thanks!

 

[Pat Hartman]

You can link to the tables.
File/Get External Date/Link
Choose ODBC at the bottom of the file type list and then choose the DSN that identifies your SQL database. You will then get a list of tables from that database. Choose the ones you want to link.

Once the tables are linked, you can write standard Access queries to join them as necessary.

 

[Alamir]

Best DSN

open control panel ... and choosee ODBC (in win 2000 .. click on Administrative Tools ..then Data Source (ODBC) ...)

and make System DSN (all user on this machine can see and use it)... because it is the best DSN
but you have to make this System DSN on all machines

bye
alamir_mohamed@yahoo.com