database issues...solution required

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

eswar - 26 Nov 2004 09:23 GMT

hi all,
i am trying to connect database to my sharepoint portal. i learned that
there are 2 ways of doing that.
1) using data view webpart
2) using infopath
if i am not wrong, using data view webpart we can just view the table.
when infopath is used, the table opens up in infopath for viewing and
updating.
somebody please tell me how to manipulate a table by opening it within the
portal site. are there any other options to access a database other the
above mentioned 2?

thnx & regards
eswar

Reply to this Message

acollazos - 26 Nov 2004 16:47 GMT

I usually save the access table as an Access Data Page, posting it to any
available web server, from the Portal I create a Web Part to view a Web PAge
with the hyperlink to the Data Access Page. Give it a try.

> hi all,
> i am trying to connect database to my sharepoint portal. i learned that
[quoted text clipped - 10 lines]
> thnx & regards
> eswar

Reply to this Message

eswar - 29 Nov 2004 04:24 GMT

hi acollazos,
i am bit confused. will you please tell me how to save a access table as
an access data page. and if done so, can we edit the database table? kindle
explain this sitation.
thnx & reg
-eswar

>I usually save the access table as an Access Data Page, posting it to any
> available web server, from the Portal I create a Web Part to view a Web
[quoted text clipped - 17 lines]
>> thnx & regards
>> eswar

Reply to this Message

acollazos - 29 Nov 2004 13:21 GMT

In Access.. open the table you want to edit>> from the datasheet view go to
File > Save as >> Enter the name in the first box >> in the second box select
as "Data Access Page" > click OK ; then you will be prompted for the
directory where you are going to save the html file to...(usualy the home
directory for the website you are going to use to view it using the Web Page
Viewer Web Part form the Portal)

And yes, you may edit, add and delete records provided that the original
table allows it.

Good Luck

> hi acollazos,
> i am bit confused. will you please tell me how to save a access table as
[quoted text clipped - 23 lines]
> >> thnx & regards
> >> eswar

Reply to this Message

eswar - 30 Nov 2004 05:34 GMT

hi acollazo,
thnx for that. i tried it and almost got the solution, but gt struck at a
point. when i browse and add the page i am getting a page error. the error
is:
" line 82
char3
error: access is denied
code:0
URL: http://<portal site name>/ sites/xxx/default.aspx
"
where posrtal site name is our portal server name & xxx is a site created by
me.
pl give me a solution for this.

thnx & reg
-eswar

> In Access.. open the table you want to edit>> from the datasheet view go
> to
[quoted text clipped - 43 lines]
>> >> thnx & regards
>> >> eswar

Reply to this Message

acollazos - 15 Dec 2004 16:09 GMT

for an access data page to work in this kind of environment the original
tables have to be hosted in a network share where the users are authorized to
read. You may choose to set it up by an ODBC connection or by a network share
present in all the end users machines; all dependes the level of security on
this particular network setup. Good Luck

> hi acollazo,
> thnx for that. i tried it and almost got the solution, but gt struck at a
[quoted text clipped - 59 lines]
> >> >> thnx & regards
> >> >> eswar

Reply to this Message