form data over the internet?

  • Thread starter Thread starter 111
  • Start date Start date
1

111

I have set up an ftp server and would like to know how i can automatically send
certain data from my .mdb file (on an hourly basis) so I can log into the
server from any internet connection to view the data

I suspect the best format to xfer the data from the Form would be a .txt file
so that any computer i'm using to log into the ftp site will be able to read
the data.If there is a better way please let me know.(perhaps html?)

I really don't know where to begin. I have a form which shows daily statistics
that i want to be updated on the server (hourly) so that i can log in from any
internet connection (worldwide) to view the stats. I'm not fussy about the
format of the data i only need to see the numbers.

any suggestions would be greatly appreciated.
tks
 
111 said:
I have set up an ftp server and would like to know how i can
automatically send certain data from my .mdb file (on an hourly
basis) so I can log into the server from any internet connection to
view the data

I suspect the best format to xfer the data from the Form would be a
.txt file so that any computer i'm using to log into the ftp site
will be able to read the data.If there is a better way please let me
know.(perhaps html?)

I really don't know where to begin. I have a form which shows daily
statistics that i want to be updated on the server (hourly) so that i
can log in from any internet connection (worldwide) to view the
stats. I'm not fussy about the format of the data i only need to see
the numbers.

any suggestions would be greatly appreciated.
tks
Click to expand...

It seems reasonable to write the required data out to a text file. If
it comes from a table or query, the DoCmd.TransferText method may be
useful to write it out. If not, you may need to use the built-in VBA
file I/O statements like Open, Print # (or Write), and Close.

For FTPing, you may want to try the Internet Transfer Library posted at

http://www.mvps.org/access/modules/mdl0037.htm

I've used it for HTTP (reading web pages), not for FTP, so I can't tell
you much about that aspect of it, but there are examples in the
download.
 
Hi,

From your descriptions, I understood that you would like to access your mdb
data via Internet connections. Have I understood you? If there is anything
I misunderstood, please feel free to let me know :)

However, I am not very sure about your process. Do you want to know how to
convert Access data to txt format? What do you want to do with FTP Server?

Based on my experience, you should take the following things into
consideration
1. Security
Do you have much concerns on the security of your data? If so, please make
sure that you have make it safe enough.

2. How about email sending?
We could use Access to send email to **** email address at a scheduled time.

3. If you are using HTML, I think it is the most effective way to do it.
Also, please take the security of data

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng
Microsoft Developer Community Support
 
Hi,

I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng
Microsoft Developer Community Support
 
Back
Top