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  1535 
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 
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:...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
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...
|
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,...
| |
