I am currently creating a database for a new company that we acquired. There are a small number of private sales reps based out of their homes. Initially, these people were sending in files/order forms(mostly excel files) of their sales that need to be entered in one database. With all of these reps providing bad data without constraints, generating reports with good data will be a nightmare. Managers have looked at having someone implement this as part of their website, but it is "too costly" (they are cheap). I don't really want to volunteer to do this because building databases is only a task that I perform in my downtime. Well, I thought that we may be able to get better control of the data and eliminate us re-entering data by using a data access page. Unfortunately, all our websites are hosted on an external web host and my IT guy does not like researching and we couldn't figure it out. Anyway, are data access pages an appropriate solution to my problem? (I only have access 2000 right now, but may be able to come up with a newer version) Can I properly utilize data access pages on an external web server(it does have SQL capabilities)? If not, could someone please suggest a solution. Any help would be much appreciated.
Thanks,
Geoff
2  1561 
I am currently creating a database for a new company that we acquired. There are a small number of private sales reps based out of their homes. Initially, these people were sending in files/order forms(mostly excel files) of their sales that need to be entered in one database. With all of these reps providing bad data without constraints, generating reports with good data will be a nightmare. Managers have looked at having someone implement this as part of their website, but it is "too costly" (they are cheap). I don't really want to volunteer to do this because building databases is only a task that I perform in my downtime. Well, I thought that we may be able to get better control of the data and eliminate us re-entering data by using a data access page. Unfortunately, all our websites are hosted on an external web host and my IT guy does not like researching and we couldn't figure it out. Anyway, are data access pages an appropriate solution to my problem? (I only have access 2000 right now, but may be able to come up with a newer version) Can I properly utilize data access pages on an external web server(it does have SQL capabilities)? If not, could someone please suggest a solution. Any help would be much appreciated.
Thanks,
Geoff
Take a look at this Link and other Pages perhaps it might help you to start with your Project. http://msaccesstips.com/2007/04/usin...internet.shtml  ADezii 8,834
Recognized Expert Expert
I am currently creating a database for a new company that we acquired. There are a small number of private sales reps based out of their homes. Initially, these people were sending in files/order forms(mostly excel files) of their sales that need to be entered in one database. With all of these reps providing bad data without constraints, generating reports with good data will be a nightmare. Managers have looked at having someone implement this as part of their website, but it is "too costly" (they are cheap). I don't really want to volunteer to do this because building databases is only a task that I perform in my downtime. Well, I thought that we may be able to get better control of the data and eliminate us re-entering data by using a data access page. Unfortunately, all our websites are hosted on an external web host and my IT guy does not like researching and we couldn't figure it out. Anyway, are data access pages an appropriate solution to my problem? (I only have access 2000 right now, but may be able to come up with a newer version) Can I properly utilize data access pages on an external web server(it does have SQL capabilities)? If not, could someone please suggest a solution. Any help would be much appreciated.
Thanks,
Geoff
Publishing Access Data on the Web Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: sinna |
last post by:
Hi!
I'm new in JavaScript, and tried out some examples.
If found an XML example at MSDN MSXML 4.0 DOM which is:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/htm/xml_mth_hn_2uck.asp
var xmlDoc = new ActiveXObject("Msxml2.DOMDocument.4.0");
xmlDoc.async = false;
xmlDoc.resolveExternals = false;
|
by: rob |
last post by:
Hi to all.
I am pretty new to using Access and am having a problem I hope someone
can help me with.
I want to access a MS-Access database from a web page. I have managed
to get it "sort" of working using MS-Access's 'data access page'
function as it were.
This creates a web page that is linked to a database table. The
problem that
I have is that if data in the dbase is changed, it does not
immediately reflect
|
by: rcmail14872 |
last post by:
I created a simple Data Access Page and it views fine in Internet
Explorer 5.5 on my PC. But when I try to view it on my Pocket PC
running Pocket PC 2002 operating system, I get the error message that
the page needs Internet Explorer 5.5 or higher to display. Does anyone
know if the version of Internet Explorer that comes with Pocket PC 2003
or the latest version of Windows CE supports Data Access Pages?
|
by: TheCoder |
last post by:
I am making a D-base with web conectivity for my class project. I have
everything working but the subit button sends the data to the correct
fields but afterwards it wants to reproduce new blank text boxes how do
I stop this and how would I code it to redirect to a thank you page.
All with out the help of a web server this has to br ran from the
desktop and with in IE with a local directory. Pleas help I am stuck.
here is the code!
...
|
by: tina.boroff |
last post by:
I have just created a form for a Maintenance Database that has alot of
VB code involved. Now they want the form on our Intranet instead. Is
there a way that anyone knows to publish the form including code, data
sources, etc to the internet. I am using Frontpage and Access 2003.
Thanks
Tina
| | |
by: Lyle Fairfield |
last post by:
In a recent thread there has been discussion about Data Access Pages. It
has been suggested that they are not permitted on many or most secure sites.
Perhaps, that it is so, although I know of no site that has this
prohibition, and I have uploaded DAPs to various sites and used them
from those sites.
I do not understand why any site manager would prohibit DAPs. To the
best of my knowledge DAPs, as HTM files, are merely hosted on the...
|
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: 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: simon.robin.jackson |
last post by:
Ok, please bare with me, im not a web developer. I am an intermediate
Access database user.
We collect data for a company that has 20 monitoring stations. Once a
month they collate all the data together and send it to us. We have
an access database that (via macros) we merge the data into. This has
been going on for a few years now.
If they want to know something about their data, they ring up, we look
at the database and send out...
|
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: 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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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...
| |
