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

MS Access as a web darabase?

P: n/a
AF
Can I use Access to deliver web pages?

I have two types of web pages on my sites. Complex ones, with tables,
pictures, special effects, and other objects. I will keep these in
FrontPage.

Other pages have only text, like reciprocal links pages.

Can I use Access to deliver these pages?

For example,

I may want to create a record for each reciprocal link, with fields
like url, title, description, category.

Then I would want to show a page of links based on categories using
this type of html (which may not be grammatically correct)

"<a href" + url +" >" + title + "</a>" + description

I would need Access to retrieve all records that have a category that
I am looking for and compaose a list of the records show the line
above for each record. Is this possible?

Thanks for any help.
Best regards,

Al
http://www.affordablefloridainsurance.com
http://www.americanbestmortgages.com
Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Although it is possible to use Access with a website, I wouldn't do it. A
hacker could download your entire database without expending much effort. I
would use MySQL to store your website data instead, and if you want, you can
link your MySQL tables to Access so you'll have the same data interface that
you're used to working with.

Linda

"AF" <bscinc3000@Yahoo_NoSpam.com> wrote in message
news:28********************************@4ax.com...
Can I use Access to deliver web pages?

I have two types of web pages on my sites. Complex ones, with tables,
pictures, special effects, and other objects. I will keep these in
FrontPage.

Other pages have only text, like reciprocal links pages.

Can I use Access to deliver these pages?

For example,

I may want to create a record for each reciprocal link, with fields
like url, title, description, category.

Then I would want to show a page of links based on categories using
this type of html (which may not be grammatically correct)

"<a href" + url +" >" + title + "</a>" + description

I would need Access to retrieve all records that have a category that
I am looking for and compaose a list of the records show the line
above for each record. Is this possible?

Thanks for any help.
Best regards,

Al
http://www.affordablefloridainsurance.com
http://www.americanbestmortgages.com

Nov 13 '05 #2

P: n/a
AF
On Tue, 14 Jun 2005 19:10:02 GMT, "Linda Burnside"
<linda@nospam_burnsidebiz.com> wrote:
Although it is possible to use Access with a website, I wouldn't do it. A
hacker could download your entire database without expending much effort. I
would use MySQL to store your website data instead, and if you want, you can
link your MySQL tables to Access so you'll have the same data interface that
you're used to working with.

Linda

"AF" <bscinc3000@Yahoo_NoSpam.com> wrote in message
news:28********************************@4ax.com.. .
Can I use Access to deliver web pages?

I have two types of web pages on my sites. Complex ones, with tables,
pictures, special effects, and other objects. I will keep these in
FrontPage.

Other pages have only text, like reciprocal links pages.

Can I use Access to deliver these pages?

For example,
Thanks for the information. Are there any good books, online
tutorials, etc. on how to do your suggestion?

I guess first I have to figure out how to use MySQL, and then how to
connect to Access.

Thanks again. I may want to create a record for each reciprocal link, with fields
like url, title, description, category.

Then I would want to show a page of links based on categories using
this type of html (which may not be grammatically correct)

"<a href" + url +" >" + title + "</a>" + description

I would need Access to retrieve all records that have a category that
I am looking for and compaose a list of the records show the line
above for each record. Is this possible?

Thanks for any help.
Best regards,

Al
http://www.affordablefloridainsurance.com
http://www.americanbestmortgages.com


Best regards,

Al
http://www.affordablefloridainsurance.com
http://www.americanbestmortgages.com
Nov 13 '05 #3

P: n/a
AF <bscinc3000@Yahoo_NoSpam.com> wrote in
news:28********************************@4ax.com:
Can I use Access to deliver web pages?
No.

You could use a Jet database to store the data you deliver on a web
page, though. You can use Access to create that database, but
nothing of the Access part of the database will be used by the web
site.
I have two types of web pages on my sites. Complex ones, with
tables, pictures, special effects, and other objects. I will keep
these in FrontPage.

Other pages have only text, like reciprocal links pages.

Can I use Access to deliver these pages?
No. But an MDB could be used to store the lists, and then you'd need
to use some kind of server-side scripting language to retrieve the
list when it's requrested.
For example,

I may want to create a record for each reciprocal link, with
fields like url, title, description, category.

Then I would want to show a page of links based on categories
using this type of html (which may not be grammatically correct)

"<a href" + url +" >" + title + "</a>" + description

I would need Access to retrieve all records that have a category
that I am looking for and compaose a list of the records show the
line above for each record. Is this possible?


Again, Access is not a server database, so can't act as part of a
web page (except in ways that you don't want to get into).

But you can use Access to create an MDB file (which is Jet) to store
data in, and then write code to retrieve data from there.

Ignore the advice about MySQL. It comes from someone who is either
ignorant or prejudiced. There's nothing magical about putting your
MDB file in a path accessible to the server-side code that can't be
accessed from the HTTP server.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #4

P: n/a
AF wrote:
Can I use Access to deliver web pages?

I have two types of web pages on my sites. Complex ones, with tables,
pictures, special effects, and other objects. I will keep these in
FrontPage.

Other pages have only text, like reciprocal links pages.

Can I use Access to deliver these pages?

For example,

I may want to create a record for each reciprocal link, with fields
like url, title, description, category.

Then I would want to show a page of links based on categories using
this type of html (which may not be grammatically correct)

"<a href" + url +" >" + title + "</a>" + description

I would need Access to retrieve all records that have a category that
I am looking for and compaose a list of the records show the line
above for each record. Is this possible?

Thanks for any help.
Best regards,

Al
http://www.affordablefloridainsurance.com
http://www.americanbestmortgages.com

Take a look at my web page for lots of info on this topic

http://members.cox.net/tulsaalstons/...20Internet.htm

Bob
Nov 13 '05 #5

P: n/a
Any database, including the Access's Default Microsoft JET Database can
be used anywhere there is a technology available to connect to the
database. Many sites use ASP, ADO and HTML Forms to facilitate an
interactive web GUI with a JET Database. At one time, depending on how
this db was created, it might not have an Access reference at all. (I
do not know if this is still possible).
Often we are told this is inefficient with some number such as 25 being
advanced as the maximum number of concurrent users a JET (Access)
database can support. As HTML forms are not bound (except when using
some MS "magic!" such as data binding) this concern may not be
warranted. Typically, an ADO Connection opens and closes in a fraction
of a second, and can wait. So in fact we can have many, many users, who
seem to be "concurrent" but in fact are part of a queue which is almost
always available.
Client Access can be programmed to write HTML files and to upload them
to a server using FTP or ADO (no, really! ... ADO). I have written such
an application for a genealogy site. These files can be written and
uploaded very very quickly, if memory serves me correctly, 7000
in less than 2 minutes..
But I know of no way of having Access running on a server and being
used on the Internet, except through some utility such as Terminal
Server. I shudder at the thought of one server running many instances
of a program, but there is much support for TS Access use here in CDMA
and I have to yield to those with more experience with this than I.
Data Access Pages are a close approximation of Access on the Web. But
DAPs require Office software on the client machine, and many
developers, including me, have found them to be less than sufficiently
responsive and malleable.

Nov 13 '05 #6

P: n/a
On Tue, 14 Jun 2005 15:43:25 GMT, AF <bscinc3000@Yahoo_NoSpam.com>
wrote:
Can I use Access to deliver web pages?

I can say something about this: for the last three years I have been
developing web interfaces to ms-access and sql server databases.
Mostly for our internal intranet - but also as a service provider to
outside clients.

To make a long,long story short, we pushed ms-access to its limits.
Conclusion?

Yes - you can use the Jet database MDB file (97,2000, whatever) as a
store for data and provide a HTML front-end for it in a web browser.
However, it requires A LOT of work and very careful server setup.
There are a lot of issues: Security, Connections, etc.

I've been using ASP for the last three years and am just now
transitioning to .NET. You have to know how to get your data and get
back out of the database as fast as possible. It's all about
connections to your database. It's true that you really don't want a
whole lot of people (less than 25) connecting to a jet mdb file at the
**same** time -- but that's the point: they don't access it at the
same time: they take turns. You design the web pages to make a quick
connection, get some data, and then disconnect.

We have hundred's connecting to one of our last remaining ms-access
db's (the rest have been up-sized to sql server). It's made up of 2
mdb files because of size limits with each db closing in on 1 gig in
size.

When I see someone ask whether you can use ms-access to serve web
pages I cringe inside === not because jet isn't a good database,
because it is. But because it requires knowledge and skill in setup of
the web site and the server that hosts it.

If you have to ask that question, you don't have that knowledge and
you have a long, long road ahead of you.

In many ways, sql server is much, much easier. Now that we are finally
almost moved over to sql server, it's so much better I can hardly
believe it.
Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.