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

Viewing Access data on the web

P: n/a
Hi,

I have created a database that is used to store contact information for
NGO's accross India. It is simple in structure and I want a portion of
the data to be viewable on the Internet.

I want the information to be available for read access only.

What is the potential for using Data Access pages for this task and
what are the key questions/technologies I need to address before I can
achieve this?

Any help would be much appreciated.

Thanks,

Tom

Dec 22 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On 21 Dec 2006 22:58:47 -0800, to********@googlemail.com wrote:

Zero. DAP is for intranet applications.
Access is not the best database behind a webapp, but if traffic is
expected to be low, it should be OK.
Probably easiest would be to have a competent developer write a DotNet
application. Using gridviews, this can be done very quickly. If
necessary usage of the application can be regulated using the new
Login controls in VS2005. If you are new to all of this: I don't want
to discourage you, but expect a steep learning curve.

-Tom.

>Hi,

I have created a database that is used to store contact information for
NGO's accross India. It is simple in structure and I want a portion of
the data to be viewable on the Internet.

I want the information to be available for read access only.

What is the potential for using Data Access pages for this task and
what are the key questions/technologies I need to address before I can
achieve this?

Any help would be much appreciated.

Thanks,

Tom
Dec 22 '06 #2

P: n/a
to********@googlemail.com wrote:
I have created a database that is used to store contact information for
NGO's accross India. It is simple in structure and I want a portion of
the data to be viewable on the Internet.

I want the information to be available for read access only.

What is the potential for using Data Access pages for this task and
what are the key questions/technologies I need to address before I can
achieve this?
If you store your data in a database on a web-available server, such as
MS-SQL Server, a DAP can do what you describe.
One can rent MS-SQL space for $10 (US) per month.

DAPs do not hide logon parameters. Someone who examines the DAP source
may be able to find logon and password values.

DAPs require Internet Explorer and an Office License on each user's
machine (or used to; MS may have modified the requirements.)

ASP and ASP.Net applications can use a JET db hosted on a web server,
as well as MS-SQL and other sources. They are likely to be more secure
in that their logons are or should be concealed.

Sharepoint Services and Terminal Server are other possibilities you
might wish to look into. I know little or nothing of these and won't
comment on them.

If amount of data is small, and if its organization lends itself to
document or spreadsheet viewing, you can use Google's Docs and
Spreadsheets, create the document and make it public for viewing.

Access can be programmed to create html documents and to upload them
(unattended) to an MS Front Page or IIS web site.
http:/www.ffdba.com is untouched by human hand (nor mine either).

For static data I am experimenting with using screen capture and jpegs.
A picture displays well on the net, can be sized and is very read-only.

So my answer is; I could do this in many ways; so could you.

Dec 22 '06 #3

P: n/a
Lyle Fairfield wrote:
to********@googlemail.com wrote:
>I have created a database that is used to store contact information for
NGO's accross India. It is simple in structure and I want a portion of
the data to be viewable on the Internet.

I want the information to be available for read access only.

What is the potential for using Data Access pages for this task and
what are the key questions/technologies I need to address before I can
achieve this?

If you store your data in a database on a web-available server, such as
MS-SQL Server, a DAP can do what you describe.
One can rent MS-SQL space for $10 (US) per month.

DAPs do not hide logon parameters. Someone who examines the DAP source
may be able to find logon and password values.

DAPs require Internet Explorer and an Office License on each user's
machine (or used to; MS may have modified the requirements.)

ASP and ASP.Net applications can use a JET db hosted on a web server,
as well as MS-SQL and other sources. They are likely to be more secure
in that their logons are or should be concealed.

Sharepoint Services and Terminal Server are other possibilities you
might wish to look into. I know little or nothing of these and won't
comment on them.

If amount of data is small, and if its organization lends itself to
document or spreadsheet viewing, you can use Google's Docs and
Spreadsheets, create the document and make it public for viewing.

Access can be programmed to create html documents and to upload them
(unattended) to an MS Front Page or IIS web site.
http:/www.ffdba.com is untouched by human hand (nor mine either).

For static data I am experimenting with using screen capture and jpegs.
A picture displays well on the net, can be sized and is very read-only.

So my answer is; I could do this in many ways; so could you.
Take a look at these links for software and code to run Access reports
from the web:

http://webpages.charter.net/bobalsto...s%20from%20Web

Bob
Dec 22 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.