HTML to Access Database


J

Jack Cannon

I need to communicate with an Access Database using html commands.
Can anyone supply me with a tutorial on how to accomplish this?

Jack Cannon
 
A

Albert D. Kallal

Jack Cannon said:
I need to communicate with an Access Database using html commands.
Can anyone supply me with a tutorial on how to accomplish this?

Jack Cannon
The MS access jet database engine has no ability to interpret or understand
or use HTML at all.

remember there are two parts where we're referring to MS access.

MS Accesss - the development system. this system allowed to build reports,
build forms, and write visual basic coding. this part of the system allows
to develop applications for the windows desktop, and has absolutely no
relationship or bearing to web based systems in any shape way or form

MS Access - the JET database engine.

the jet database engine is used by many products in the marketplace, simply
accounting uses this database engine, MS access users and by default, and
even many visual basic developers use the jet database engine. it's
important to not confuse the jet database engine, or the Microsoft database
engine with that of Microsoft access a development tool. this database
engine is a file sharing in June, and can interpret SQL commands directly,
but has no ability to understand use or interpret HTML in any way shape or
form.

Note that while you can build a web site that reads and uses information
from a jet database engine fiel (ms access mdb file). The forms, the
reports, the coding system and anything else in MS access has absolutely no
relationship or no use for building web based systems.

MS access can import text files, and it does have some HTML import options I
believe. However, there is no ability to understand or interpret HTML
commands, and MS access to development tool has no relationship with the web
in that sense.

So you have the wrong approach, the wrong technology, the wrong platofmr,
and somehow been given some very wrong information in this regards as to
ms-access being able to interpret HTML.

MS access can produce (actually export is a better word) HTML from a report.
So you can sit down and build a report on your desktop, you can then export
and save that report as HTML. However interpretation of HTML is something
that has no relationship or something that MS access simply doesn't do.
MS-access is not a web based tool at all...it is a desktop system for
windows.
 
Ad

Advertisements

J

Jack Cannon

Thank you Albert.

It is clear that I worded my question very poorly. The actual objective is
to use a website to allow users to register for a seminar. It is my
understanding that there is a way to embed asp commands into what appears as
an html file but is saved with the .asp extension. <% .... %>

An mdb file containing only an appropriate table would exist on the website
that accepts the entries resulting from the user filling out an input form.
Perhaps this is the same as a guestbook application.

I could be completely wrong on my understanding and I could also be posting
the question on the wrong forum but I was hoping to get some guidance on the
subject.

Jack Cannon
 
A

Albert D. Kallal

Jack Cannon said:
Thank you Albert.

It is clear that I worded my question very poorly. The actual objective
is
to use a website to allow users to register for a seminar. It is my
understanding that there is a way to embed asp commands into what appears
as
an html file but is saved with the .asp extension. <% .... %>
The above is correct, but again we're talking about web development tools,
and a web site, and that has absolutely nothing to do with MS access.

An mdb file containing only an appropriate table would exist on the
website
that accepts the entries resulting from the user filling out an input
form.
The above is correct, there's no question that a person can build a web
site, and use web development tools, and have that web server write data to
a mdb file. Hhowever this process is not a whole lot different than having
the website write some data to a text file. so there's no question in a web
site can read and write data to an access database file, but I wanted to be
clear here that we're talking about something that's not really using MS
access at all, but is simply some windows file sitting there, that is
written to and from just as if it was a text file or something else. in
other words, you don't actually install MS access on the web site, and the
web site just sees that file.

So, if you place that access data file on the web server, you'll not be able
to run MS access at that point I'm, unless you actually have physical access
to the web server and can view/open those files in the directories that make
up the website.
Perhaps this is the same as a guestbook application.
Yes that's the correct way of thinking things, but again I just want to
stress that when you're using these web tools, they really have no
relationship to MS access. in other words that web server can write to a
text file, and then I suppose I could transfer the text file to my computer
and open it with word. however you would not state that the website is
editing or using that word file. The same conceptual thinking must be kept
in mind when you're talking about MS access in a data file.
I could be completely wrong on my understanding and I could also be
posting
the question on the wrong forum but I was hoping to get some guidance on
the
subject.
the web site could be set up to gather and have dated put into an access
database file, the problem then becomes how do you get a copy of that file,
or can you open and read files sitting on that web server (chances are
you'll not be able to do that). This issue really depends if you have your
own web server at your company and it is on the same network as your desktop
computer. if your desktop computer has access to the same folders and
directories that the website is writing to and from, then you in theory
could open up that database file also and read in use the information that
the web sites put into the access database file.

However, often is the case it's more practical for web site to use SQL
server as the data store, in that case then both the website and your MS
access front and application can both read write and use the same data at
the same time. this tends to be a more practical approach, however in this
case then you'll have to have access to the SQL server that storing the data
for that web site.

Other possible ways to are have the website gather this information, then
have the people designing and setting up the website create a daily text
file that you can download to your desktop and then import into MS access.

If you have access to the server where the website is running, then there's
no question that you can have MS access link directly to that mdb data file
sitting on the server. Or, more often you can link your ms-access
applicaion to the SQL server running on that web site.

so at the end of the day, either way, it is the web developers and
development of the web forms that's going to "gather" this input data from
the users, once the website does that, the website thing can be set up to
save the data into a text file, a mdb file, or more often SQL server. At
that point you need some means to transfer the data from the file (data)
gatherd by the web server to MS access. How transfer works will depend on if
you have physical access to the web server itself.
 
J

Jack Cannon

Thanks again Albert.
However, often is the case it's more practical for web site to use SQL
server as the data store, in that case then both the website and your MS
access front and application can both read write and use the same data at
the same time. this tends to be a more practical approach, however in this
case then you'll have to have access to the SQL server that storing the data
for that web site.
Excellent Point! I will try to find a tutorial on this approach instead.

I had only mentioned Access because I have not worked on SQL Server
since SQL 2000 and I am more current with Access.

Jack Cannon
 
P

Paul Shapiro

You could look at the asp.Net forum. ASP has been deprecated and replaced
with asp.Net. I think you'll need a book to get started. I liked "ASP.Net
3.5 Unleashed", by Stephen Walther, as a good guide to a first data-driven
website.

If all you want is to get an email when someone registers, you can do that
with static html. But if you want to a database application, asp.net is the
Microsoft tool.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top