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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2010-12-02 : 04:51:48
|
| Can I use an access front-end to an sql backend and use stored procedures in sql.Basically my question is if I will be able to link access reports to a stored procedure in sql as the record-set to retrieve the data for the report. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-02 : 05:21:58
|
| Yes.Try a search in google foraccess reports stored procedure==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2010-12-02 : 13:37:27
|
| Yes.Unless you need to store data locally in your Access database, consider creating an Access Data Project instead of a standard Access Database.________________________________________________If it is not practically useful, then it is practically useless.________________________________________________ |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2010-12-03 : 01:17:51
|
| can you use reports and forms in the same way with an asccess data project. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2010-12-03 : 10:43:25
|
| Yes.An access data project has all of the forms and reports of an Access database, but does not store any data locally. All querying and non-VB processing is performed on the database server, (as well as all security validations).________________________________________________If it is not practically useful, then it is practically useless.________________________________________________ |
|
|
|
|
|
|
access front-end to sql backend