Connecting Tech Pros Worldwide Forums | Help | Site Map

Access on web page

Mark
Guest
 
Posts: n/a
#1: Nov 12 '05
I want to put out a Excel or Access database spreadsheet on a web
page. Can I do this and will it let me update the spreadsheet or
will it be a static web page? If not then should I put it out there
as a file on the web page and open it up and then update the
spreadsheet? Please advise.
Scott McDaniel
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Access on web page


You can update a web-based Access database with many different technologies
(ASP is one of them) ... of course, your hosting service will have to
support your data access technology, and have Access installed and
configured properly on their servers. Not all of them do, as it's not the
best architecture for web servers (it's a file-server, not a client-server).
If these are in place, then you write your pages using HTML (or some other
markup language) and use something like ASP (or some othe data access
technology) to serve up your data. You would be responsible for all data
manipulation (i.e. Inserts/updates/deletes) as a web-based solution would
almost certainly NOT be data-bound. Access also has available Access Data
Pages, but I can't comment on those since I've never used them.

I can't really comment on Excel other than to say many of the same issues
would apply (i.e. the host would have to have Excel installed and configured
for "multi-user", if that's possible).

From your question, it appears that you don't fully understand the
differences between a spreadsheet and a relational database. The two are NOT
interchangeable, although they appear to be similar. What are you trying to
do?
--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP
"Mark" <teser3@hotmail.com> wrote in message
news:4992c39b.0312290408.7509500d@posting.google.c om...[color=blue]
> I want to put out a Excel or Access database spreadsheet on a web
> page. Can I do this and will it let me update the spreadsheet or
> will it be a static web page? If not then should I put it out there
> as a file on the web page and open it up and then update the
> spreadsheet? Please advise.[/color]


xzzy
Guest
 
Posts: n/a
#3: Nov 12 '05

re: Access on web page


this works for a pdf on one of my web sites, the same should work for excel:
<a href="http://www.creativedigitalimages.biz/docs/prereg.pdf"
target="_blank">Spotlight Video Registration</a>

for access data, I would use ASP to display the info as a html table. for
ASP classic, the mdb would have to be on that server. If the mdb is not
located at the ISP, then look into ASP.Net and remoting to consume that
remote data source.

John Bickmore
www.BicycleCam.com
www.Feed-Zone.com

"Scott McDaniel" <scott@no.spam.thedatabaseplace.net> wrote in message
news:l7ydncQxEqSRgm2i4p2dnA@comcast.com...[color=blue]
> You can update a web-based Access database with many different[/color]
technologies[color=blue]
> (ASP is one of them) ... of course, your hosting service will have to
> support your data access technology, and have Access installed and
> configured properly on their servers. Not all of them do, as it's not the
> best architecture for web servers (it's a file-server, not a[/color]
client-server).[color=blue]
> If these are in place, then you write your pages using HTML (or some other
> markup language) and use something like ASP (or some othe data access
> technology) to serve up your data. You would be responsible for all data
> manipulation (i.e. Inserts/updates/deletes) as a web-based solution would
> almost certainly NOT be data-bound. Access also has available Access Data
> Pages, but I can't comment on those since I've never used them.
>
> I can't really comment on Excel other than to say many of the same issues
> would apply (i.e. the host would have to have Excel installed and[/color]
configured[color=blue]
> for "multi-user", if that's possible).
>
> From your question, it appears that you don't fully understand the
> differences between a spreadsheet and a relational database. The two are[/color]
NOT[color=blue]
> interchangeable, although they appear to be similar. What are you trying[/color]
to[color=blue]
> do?
> --
> Scott McDaniel
> CS Computer Software
> Visual Basic - Access - Sql Server - ASP
> "Mark" <teser3@hotmail.com> wrote in message
> news:4992c39b.0312290408.7509500d@posting.google.c om...[color=green]
> > I want to put out a Excel or Access database spreadsheet on a web
> > page. Can I do this and will it let me update the spreadsheet or
> > will it be a static web page? If not then should I put it out there
> > as a file on the web page and open it up and then update the
> > spreadsheet? Please advise.[/color]
>
>[/color]


Scott McDaniel
Guest
 
Posts: n/a
#4: Nov 12 '05

re: Access on web page


How well does ASP.net deal with the remote Access/Jet file? I've not yet
used the technology, although it would seem that many of the same issues
involved in trying to remotely access a Jet db via connect string would
apply (i.e. corruption, severe performance issues, etc)

"xzzy" <mrbikejoc1@comcast.net> wrote in message
news:YSZHb.229427$_M.1009972@attbi_s54...[color=blue]
> this works for a pdf on one of my web sites, the same should work for[/color]
excel:[color=blue]
> <a href="http://www.creativedigitalimages.biz/docs/prereg.pdf"
> target="_blank">Spotlight Video Registration</a>
>
> for access data, I would use ASP to display the info as a html table. for
> ASP classic, the mdb would have to be on that server. If the mdb is not
> located at the ISP, then look into ASP.Net and remoting to consume that
> remote data source.
>
> John Bickmore
> www.BicycleCam.com
> www.Feed-Zone.com
>
> "Scott McDaniel" <scott@no.spam.thedatabaseplace.net> wrote in message
> news:l7ydncQxEqSRgm2i4p2dnA@comcast.com...[color=green]
> > You can update a web-based Access database with many different[/color]
> technologies[color=green]
> > (ASP is one of them) ... of course, your hosting service will have to
> > support your data access technology, and have Access installed and
> > configured properly on their servers. Not all of them do, as it's not[/color][/color]
the[color=blue][color=green]
> > best architecture for web servers (it's a file-server, not a[/color]
> client-server).[color=green]
> > If these are in place, then you write your pages using HTML (or some[/color][/color]
other[color=blue][color=green]
> > markup language) and use something like ASP (or some othe data access
> > technology) to serve up your data. You would be responsible for all data
> > manipulation (i.e. Inserts/updates/deletes) as a web-based solution[/color][/color]
would[color=blue][color=green]
> > almost certainly NOT be data-bound. Access also has available Access[/color][/color]
Data[color=blue][color=green]
> > Pages, but I can't comment on those since I've never used them.
> >
> > I can't really comment on Excel other than to say many of the same[/color][/color]
issues[color=blue][color=green]
> > would apply (i.e. the host would have to have Excel installed and[/color]
> configured[color=green]
> > for "multi-user", if that's possible).
> >
> > From your question, it appears that you don't fully understand the
> > differences between a spreadsheet and a relational database. The two are[/color]
> NOT[color=green]
> > interchangeable, although they appear to be similar. What are you trying[/color]
> to[color=green]
> > do?
> > --
> > Scott McDaniel
> > CS Computer Software
> > Visual Basic - Access - Sql Server - ASP
> > "Mark" <teser3@hotmail.com> wrote in message
> > news:4992c39b.0312290408.7509500d@posting.google.c om...[color=darkred]
> > > I want to put out a Excel or Access database spreadsheet on a web
> > > page. Can I do this and will it let me update the spreadsheet or
> > > will it be a static web page? If not then should I put it out there
> > > as a file on the web page and open it up and then update the
> > > spreadsheet? Please advise.[/color]
> >
> >[/color]
>
>[/color]


xzzy
Guest
 
Posts: n/a
#5: Nov 12 '05

re: Access on web page


no, "remoting" is completely, totally different. do a google search for
Ingo Rammer for some online articles, his books are also very good at
explaining remoting.

John Bickmore
www.BicycleCam.com
www.Feed-Zone.com

"Scott McDaniel" <scott@NO___Spam--thedatabaseplace.net> wrote in message
news:X7WdnSgbAtZ37W2iRVn-uQ@comcast.com...[color=blue]
> How well does ASP.net deal with the remote Access/Jet file? I've not yet
> used the technology, although it would seem that many of the same issues
> involved in trying to remotely access a Jet db via connect string would
> apply (i.e. corruption, severe performance issues, etc)
>
> "xzzy" <mrbikejoc1@comcast.net> wrote in message
> news:YSZHb.229427$_M.1009972@attbi_s54...[color=green]
> > this works for a pdf on one of my web sites, the same should work for[/color]
> excel:[color=green]
> > <a href="http://www.creativedigitalimages.biz/docs/prereg.pdf"
> > target="_blank">Spotlight Video Registration</a>
> >
> > for access data, I would use ASP to display the info as a html table.[/color][/color]
for[color=blue][color=green]
> > ASP classic, the mdb would have to be on that server. If the mdb is not
> > located at the ISP, then look into ASP.Net and remoting to consume that
> > remote data source.
> >
> > John Bickmore
> > www.BicycleCam.com
> > www.Feed-Zone.com
> >
> > "Scott McDaniel" <scott@no.spam.thedatabaseplace.net> wrote in message
> > news:l7ydncQxEqSRgm2i4p2dnA@comcast.com...[color=darkred]
> > > You can update a web-based Access database with many different[/color]
> > technologies[color=darkred]
> > > (ASP is one of them) ... of course, your hosting service will have to
> > > support your data access technology, and have Access installed and
> > > configured properly on their servers. Not all of them do, as it's not[/color][/color]
> the[color=green][color=darkred]
> > > best architecture for web servers (it's a file-server, not a[/color]
> > client-server).[color=darkred]
> > > If these are in place, then you write your pages using HTML (or some[/color][/color]
> other[color=green][color=darkred]
> > > markup language) and use something like ASP (or some othe data access
> > > technology) to serve up your data. You would be responsible for all[/color][/color][/color]
data[color=blue][color=green][color=darkred]
> > > manipulation (i.e. Inserts/updates/deletes) as a web-based solution[/color][/color]
> would[color=green][color=darkred]
> > > almost certainly NOT be data-bound. Access also has available Access[/color][/color]
> Data[color=green][color=darkred]
> > > Pages, but I can't comment on those since I've never used them.
> > >
> > > I can't really comment on Excel other than to say many of the same[/color][/color]
> issues[color=green][color=darkred]
> > > would apply (i.e. the host would have to have Excel installed and[/color]
> > configured[color=darkred]
> > > for "multi-user", if that's possible).
> > >
> > > From your question, it appears that you don't fully understand the
> > > differences between a spreadsheet and a relational database. The two[/color][/color][/color]
are[color=blue][color=green]
> > NOT[color=darkred]
> > > interchangeable, although they appear to be similar. What are you[/color][/color][/color]
trying[color=blue][color=green]
> > to[color=darkred]
> > > do?
> > > --
> > > Scott McDaniel
> > > CS Computer Software
> > > Visual Basic - Access - Sql Server - ASP
> > > "Mark" <teser3@hotmail.com> wrote in message
> > > news:4992c39b.0312290408.7509500d@posting.google.c om...
> > > > I want to put out a Excel or Access database spreadsheet on a web
> > > > page. Can I do this and will it let me update the spreadsheet or
> > > > will it be a static web page? If not then should I put it out there
> > > > as a file on the web page and open it up and then update the
> > > > spreadsheet? Please advise.
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]


Scott McDaniel
Guest
 
Posts: n/a
#6: Nov 12 '05

re: Access on web page


Thanks to both for the info ... ASP.net is next on my list of "stuff to
learn"

--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP
"Chuck Grimsby" <c.grimsby@worldnet.att.net.invalid> wrote in message
news:q4f1vvo7prmknkpv7dpprl7cpfn8cmnaio@4ax.com...[color=blue]
>
> ASP.Net works even better then you probably think. There are actually
> fewer problems with corruption due to the disconnected methodologies
> that web systems require. On the down side, there are a *lot* of
> things you can do with an Access interface that you'll find are
> impossible to do with a web interface. That down side will drive you
> nuts, by the way. Invest in aspirin. You'll need it!
>
> It takes about 6 months of rather intense work to start doing "useful"
> things in ASP.net, but it's well worth the effort. (My first ASP.Net
> project was done in 2 months, but 4 months later I was more then a bit
> ashamed of it....)
>
> Some useful links:
>
> http://www.4guysfromrolla.com/ Do *NOT* miss the article on working
> with the datagrid control on this site. It's a very long article, 11
> - 13 chapters if memory serves, but no one has better code samples or
> explanations of how it works and how to make it work better. Other
> articles on the site are well worth a read as well.
>
> http://gotdotnet.com/ Microsoft's own site, and (IMHO) one of the
> best that's out there. GotDotNet's message boards are better then the
> newsgroups for information, but they seriously need to let Google in
> so the search function can work to (useable) point. Usually, this is
> my first stop for help, then when I get frustrated, I go to
> 4guysfromrolla, and then a Google search.
>
> http://www.asp.net/ Another MS site, but worth the trip and a few
> hours of "look and see". There are some "sample" websites that only
> need a few hours of configuration and customization to use. Bad name
> however: "IBuySpy" <shrug> Also has the best list of other .Net
> sites on the web, so worth a bookmark.
>
>
> On Mon, 29 Dec 2003 13:19:54 -0500, "Scott McDaniel"
> <scott@NO___Spam--thedatabaseplace.net> wrote:
>[color=green]
> >How well does ASP.net deal with the remote Access/Jet file? I've not yet
> >used the technology, although it would seem that many of the same issues
> >involved in trying to remotely access a Jet db via connect string would
> >apply (i.e. corruption, severe performance issues, etc)
> >
> >"xzzy" <mrbikejoc1@comcast.net> wrote in message
> >news:YSZHb.229427$_M.1009972@attbi_s54...[color=darkred]
> >> this works for a pdf on one of my web sites, the same should work for[/color]
> >excel:[color=darkred]
> >> <a href="http://www.creativedigitalimages.biz/docs/prereg.pdf"
> >> target="_blank">Spotlight Video Registration</a>
> >>
> >> for access data, I would use ASP to display the info as a html table.[/color][/color][/color]
for[color=blue][color=green][color=darkred]
> >> ASP classic, the mdb would have to be on that server. If the mdb is[/color][/color][/color]
not[color=blue][color=green][color=darkred]
> >> located at the ISP, then look into ASP.Net and remoting to consume that
> >> remote data source.
> >>
> >> John Bickmore
> >> www.BicycleCam.com
> >> www.Feed-Zone.com
> >>
> >> "Scott McDaniel" <scott@no.spam.thedatabaseplace.net> wrote in message
> >> news:l7ydncQxEqSRgm2i4p2dnA@comcast.com...
> >> > You can update a web-based Access database with many different
> >> technologies
> >> > (ASP is one of them) ... of course, your hosting service will have to
> >> > support your data access technology, and have Access installed and
> >> > configured properly on their servers. Not all of them do, as it's not[/color]
> >the[color=darkred]
> >> > best architecture for web servers (it's a file-server, not a
> >> client-server).
> >> > If these are in place, then you write your pages using HTML (or some[/color]
> >other[color=darkred]
> >> > markup language) and use something like ASP (or some othe data access
> >> > technology) to serve up your data. You would be responsible for all[/color][/color][/color]
data[color=blue][color=green][color=darkred]
> >> > manipulation (i.e. Inserts/updates/deletes) as a web-based solution[/color]
> >would[color=darkred]
> >> > almost certainly NOT be data-bound. Access also has available Access[/color]
> >Data[color=darkred]
> >> > Pages, but I can't comment on those since I've never used them.
> >> >
> >> > I can't really comment on Excel other than to say many of the same[/color]
> >issues[color=darkred]
> >> > would apply (i.e. the host would have to have Excel installed and
> >> configured
> >> > for "multi-user", if that's possible).
> >> >
> >> > From your question, it appears that you don't fully understand the
> >> > differences between a spreadsheet and a relational database. The two[/color][/color][/color]
are[color=blue][color=green][color=darkred]
> >> NOT
> >> > interchangeable, although they appear to be similar. What are you[/color][/color][/color]
trying[color=blue][color=green][color=darkred]
> >> to
> >> > do?
> >> > --
> >> > Scott McDaniel
> >> > CS Computer Software
> >> > Visual Basic - Access - Sql Server - ASP
> >> > "Mark" <teser3@hotmail.com> wrote in message
> >> > news:4992c39b.0312290408.7509500d@posting.google.c om...
> >> > > I want to put out a Excel or Access database spreadsheet on a web
> >> > > page. Can I do this and will it let me update the spreadsheet or
> >> > > will it be a static web page? If not then should I put it out[/color][/color][/color]
there[color=blue][color=green][color=darkred]
> >> > > as a file on the web page and open it up and then update the
> >> > > spreadsheet? Please advise.
> >> >
> >> >
> >>
> >>[/color]
> >[/color]
>
>
> --
> System Error. Press F13 To Continue.
>[/color]


Mark
Guest
 
Posts: n/a
#7: Nov 12 '05

re: Access on web page


Thanks Scott,

I assume One table with rows and columns is a spreadsheet? I am not
using multiple tables with relational database.
And if so I can just save it as a static Access web page which can be
viewed on the web? To update or manipulate this spreadsheet I would
need to use ASP or Cold Fusion?
Danny J. Lesandrini
Guest
 
Posts: n/a
#8: Nov 12 '05

re: Access on web page


Check out these articles at my web site:

http://www.amazecreations.com/datafa...m&Article=true
http://www.amazecreations.com/datafa...m&Article=true

--

Danny J. Lesandrini
dlesandrini@hotmail.com
http://amazecreations.com/datafast


"Mark" <teser3@hotmail.com> wrote ...[color=blue]
> Thanks Scott,
>
> I assume One table with rows and columns is a spreadsheet? I am not
> using multiple tables with relational database.
> And if so I can just save it as a static Access web page which can be
> viewed on the web? To update or manipulate this spreadsheet I would
> need to use ASP or Cold Fusion?[/color]


Mark
Guest
 
Posts: n/a
#9: Nov 12 '05

re: Access on web page


Thanks
Peter Chong
Guest
 
Posts: n/a
#10: Nov 12 '05

re: Access on web page


"Scott McDaniel" <scott@NO___Spam--thedatabaseplace.net> wrote in message news:<X7WdnSgbAtZ37W2iRVn-uQ@comcast.com>...[color=blue]
> How well does ASP.net deal with the remote Access/Jet file? I've not yet
> used the technology, although it would seem that many of the same issues
> involved in trying to remotely access a Jet db via connect string would
> apply (i.e. corruption, severe performance issues, etc)
>[/color]

once you install framework 1.1 in your II server, you could generate
an asp.net code from your access database, code gen wizard program is
in www.exmlsoft.com -> download.
Closed Thread