database issues...solution required

[eswar]

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

 

[acollazos]

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.

 

[eswar]

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

 

[acollazos]

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

 

[eswar]

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

 

[acollazos]

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