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. 9 1688
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.goo gle.com... 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.
this works for a pdf on one of my web sites, the same should work for excel:
<a href="http://www.creativedig italimages.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. thedatabaseplac e.net> wrote in message
news:l7******** ************@co mcast.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.goo gle.com... 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.
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********@com cast.net> wrote in message
news:YSZHb.2294 27$_M.1009972@a ttbi_s54... this works for a pdf on one of my web sites, the same should work for
excel: <a href="http://www.creativedig italimages.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. thedatabaseplac e.net> wrote in message news:l7******** ************@co mcast.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.goo gle.com... 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.
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___Spa m--thedatabaseplac e.net> wrote in message
news:X7******** ************@co mcast.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********@com cast.net> wrote in message news:YSZHb.2294 27$_M.1009972@a ttbi_s54... this works for a pdf on one of my web sites, the same should work for excel: <a href="http://www.creativedig italimages.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. thedatabaseplac e.net> wrote in message news:l7******** ************@co mcast.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.goo gle.com... > 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.
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.*******@worl dnet.att.net.in valid> wrote in message
news:q4******** *************** *********@4ax.c om... 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___Spa m--thedatabaseplac e.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********@com cast.net> wrote in message news:YSZHb.229 427$_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.creativedig italimages.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. thedatabaseplac e.net> wrote in message news:l7******** ************@co mcast.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.goo gle.com... > > 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.
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?
"Scott McDaniel" <scott@NO___Spa m--thedatabaseplac e.net> wrote in message news:<X7******* *************@c omcast.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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Paul |
last post by:
Hi all, at present I I've built a website which can be updated by admin and
users.
My problem, I've combined "log in" and "access levels" to restrict access to
certain pages, using the built in "log in" and "user authentication,
restrict access to page" features. But I find the after login I constantly
get redirected from the restricted pages.
|
by: Sean C. |
last post by:
Helpful folks,
Most of my previous experience with DB2 was on s390 mainframe systems
and the optimizer on this platform always seemed very predictable and
consistent. Since moving to a WinNT/UDB 7.2 environment, the choices
the optimizer makes often seem flaky. But this last example really
floored me. I was hoping someone could explain why I get worse
response time when the optimizer uses two indexes, than when it uses
one. Some context:
|
by: John Baker |
last post by:
Hi:
I am URGENTLY in need of some book or web site OR tool that will help me integrate a
relatively simple access application into a web page or pages. This is a time recording
system (by project), and I would be more than wiling to pull the updated database down
from the Host using FTP on a monthly basis. Its just that I need to understand how to set
it up on the web site itself. The Host supports SQL.
Any direction you can give would...
|
by: ASP.Confused |
last post by:
The old message looked a little stale, so I am re-posting it here. Anybody
have any ideas of what I could do?!? The previous responses to this
question are below. If you want to look at the original question, the
subject line is:
ADODB.NET and "Access Denied"
I have an ASP.NET page writtein in VB that uses ADODB. I just had to
|
by: Cheryl Langdon |
last post by:
Hello everyone,
This is my first attempt at getting help in this manner. Please
forgive me if this is an inappropriate request.
I suddenly find myself in urgent need of instruction on how to
communicate with a MySQL database table on a web server, from inside
of my company's Access-VBA application. I know VBA pretty well but
have never before needed to do this HTTP/XML/MySQL type functions.
| |
by: jbonifacejr |
last post by:
This is my first day here, so please be patient. I do not know how to
search very well so the search I tried to get the answer showed me
topics from the year 2000 and they really don't cover what I want.
I am trying to open MSAccess from ASP..I guess I would use
server.createobject("Access.Application")
OK, but where do i go from there to run a report and have it print to
the default printer?
|
by: Wayne Smith |
last post by:
I've come up against a major headache that I can't seem to find a solution
for but I'm sure there must be a workaround and I would really be grateful
of any help.
I'm currently building a web site for a small club I belong to and one of
the features I would like to include is the ability to allow users to upload
image files.
unfortunately the servers web root www folder only allows READ and EXECUTE
permissions, which makes it...
|
by: =?Utf-8?B?SmF5IFBvbmR5?= |
last post by:
I am trying to access a Public property on a Master Page from a Base Page.
On the content pages I have the MasterType Directive set up as follows:
<%@ MasterType virtualpath="~/Master.master" %>
On the Master Page I have a public property exposed:
Public Property ErrorMessage() As String
Get
Return txtError.InnerText
End Get
|
by: ADezii |
last post by:
There are essentially three techniques for publishing Access Data on the Web. The first technique is static, and does not allow for the dynamic addition or modification to the data, There is no direct link to the data, and in order to update it, you must republish. I am referring to the HTML Format. The second format, IDC, is an older, obsolete technology that runs on Microsoft web Servers. IDC has limited functionality, no script language...
|
by: Andy B |
last post by:
I have a class I am creating for data access. I need to access controls from
inside the class that are on a particular page. How do I do this? or is
creating an instance of the page class and using FindControl the only way to
do it?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |