By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,667 Members | 2,611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,667 IT Pros & Developers. It's quick & easy.

Access on web page

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
9 Replies


P: n/a
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" <te****@hotmail.com> wrote in message
news:49**************************@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.

Nov 12 '05 #2

P: n/a
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" <sc***@no.spam.thedatabaseplace.net> wrote in message
news:l7********************@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 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" <te****@hotmail.com> wrote in message
news:49**************************@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.


Nov 12 '05 #3

P: n/a
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" <mr********@comcast.net> wrote in message
news:YSZHb.229427$_M.1009972@attbi_s54...
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" <sc***@no.spam.thedatabaseplace.net> wrote in message
news:l7********************@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 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" <te****@hotmail.com> wrote in message
news:49**************************@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.



Nov 12 '05 #4

P: n/a
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:X7********************@comcast.com...
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" <mr********@comcast.net> wrote in message
news:YSZHb.229427$_M.1009972@attbi_s54...
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" <sc***@no.spam.thedatabaseplace.net> wrote in message
news:l7********************@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 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" <te****@hotmail.com> wrote in message
news:49**************************@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.



Nov 12 '05 #5

P: n/a
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.*******@worldnet.att.net.invalid> wrote in message
news:q4********************************@4ax.com...

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:
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" <mr********@comcast.net> wrote in message
news:YSZHb.229427$_M.1009972@attbi_s54...
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" <sc***@no.spam.thedatabaseplace.net> wrote in message
news:l7********************@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

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" <te****@hotmail.com> wrote in message
> news:49**************************@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.
>
>

--
System Error. Press F13 To Continue.

Nov 12 '05 #6

P: n/a
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?
Nov 12 '05 #7

P: n/a
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
dl*********@hotmail.com
http://amazecreations.com/datafast
"Mark" <te****@hotmail.com> wrote ...
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?

Nov 12 '05 #8

P: n/a
Thanks
Nov 12 '05 #9

P: n/a
"Scott McDaniel" <scott@NO___Spam--thedatabaseplace.net> wrote in message news:<X7********************@comcast.com>...
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)


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.
Nov 12 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.