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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-12-06 : 09:06:57
|
| Eugène writes "Hello,I have a SQL Server database and I want to give access to part of the data to clients using the web (I am presenting the data in a pivot table way). So I did an *.adp (Access project) to get the reporting capabilities of Access. I did put my “data access page” on the web. I can access the page on the web, but there is no data on the page. How do I put my data on the web using Microsoft Access “Data access page”?Can somebody please help?Thank youEugène" |
|
|
Hugo
Starting Member
3 Posts |
Posted - 2002-12-06 : 11:00:08
|
| Hi.Well, I maybe saying a lot of B*LLSH*T here, I'm not familiar with SQL servers. And I do not use this resource of the M$ Access. BUT, maybe your page IS NOT without data.It could be that you have the data there, but you simple don't have it displayed.Access your page and then use the option "open source code" from your browser. And then check if there are any kind of relevant data in the txt.If the answer is YES, then you juz have to display your data. If it's NOT, well, I could sugest you to use the ol' ASP+M$ ACCESS combo to read and write your stuff on the web.Hope my words helped in some way.[]'s- Trying to survive - |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-12-07 : 11:26:05
|
| Your data access page is like any other report or form in access it has a record source. Take a look a the record source and see why it's not returning any data. You also need to have the office 10 web components installed to view data access pages. |
|
|
|
|
|
|
Using Access