Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mbevon
Starting Member
41 Posts |
 Posted - 2003-01-31 : 09:44:41
|
| I've just created an Access Adp as the front end for a sql server.How could i query a table on the server and return the access report name rpt1?thanks |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-01-31 : 12:04:14
|
| 1.give read access to the base table.2.create a stored procedure that runs the select query for you 3.give the permissions to execute the stored procedure.4.create a report5. assign report source name of stored procedure. |
 |
|
|
|
|
|
MS Access Adp FrontEnd