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.