If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
form data over the internet?
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 |
#2
|
|||
|
|||
form data over the internet?
"111" wrote in message
able.rogers.com 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 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. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
#3
|
|||
|
|||
form data over the internet?
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 --------------------------------------------------------------- Introduction to Yukon! - http://www.microsoft.com/sql/yukon This posting is provided "as is" with no warranties and confers no rights. Please reply to newsgroups only, many thanks! |
#4
|
|||
|
|||
form data over the internet?
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 --------------------------------------------------------------- Introduction to Yukon! - http://www.microsoft.com/sql/yukon This posting is provided "as is" with no warranties and confers no rights. Please reply to newsgroups only, many thanks! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data not saving in the continous form | wesbird | Using Forms | 0 | July 6th, 2004 07:51 PM |
How to syncronize a datasheet form and single form? | Sandra | Using Forms | 9 | June 16th, 2004 05:24 AM |
Mail Merge Form and Data (Word XP) | Sharon | Mailmerge | 1 | May 7th, 2004 10:21 AM |
Linking Excel data through Access to use a Form as an Interface | Laura | Links and Linking | 0 | March 23rd, 2004 04:59 PM |