Creating Reports

In Microsoft access , Im using local tables or report
tables to create a repor that I manipulate from the Main
database which is a Access database also, how I can make
a report for SQL Server database
What about creating linked tables in Access, did you try this alreads ?
One Possibility is : If you are using a DSN u can link these objects in
Access via a ODBC Datasource
HTH, Jens Smeyer.
http://www.sqlserver2005.de
"Arnel Lizardo" <arnellizardo@.yahoo.com> schrieb im Newsbeitrag
news:047401c54007$7be52250$a401280a@.phx.gbl...
> In Microsoft access , Im using local tables or report
> tables to create a repor that I manipulate from the Main
> database which is a Access database also, how I can make
> a report for SQL Server database

Creating Reports

In Microsoft access , Im using local tables or report
tables to create a repor that I manipulate from the Main
database which is a Access database also, how I can make
a report for SQL Server databaseWhat about creating linked tables in Access, did you try this alreads ?
One Possibility is : If you are using a DSN u can link these objects in
Access via a ODBC Datasource
HTH, Jens Smeyer.
http://www.sqlserver2005.de
--
"Arnel Lizardo" <arnellizardo@.yahoo.com> schrieb im Newsbeitrag
news:047401c54007$7be52250$a401280a@.phx.gbl...
> In Microsoft access , Im using local tables or report
> tables to create a repor that I manipulate from the Main
> database which is a Access database also, how I can make
> a report for SQL Server database