468,769 Members | 2,263 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,769 developers. It's quick & easy.

Access on the Internet: Data Access Page?

5
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
Apr 10 '08 #1
2 1321
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
Apr 14 '08 #2
ADezii
8,800 Expert 8TB
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
Apr 15 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

16 posts views Thread by sinna | last post: by
reply views Thread by TheCoder | last post: by
4 posts views Thread by tina.boroff | last post: by
3 posts views Thread by Lyle Fairfield | last post: by
9 posts views Thread by Wayne Smith | last post: by
3 posts views Thread by simon.robin.jackson | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.