RE: sharing info between Access and a website

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for the input. Your scenario is similar to what I want to do.

If I was doing the entire job I'd go with Asp.Net, but I'm not developing
the website software. It's another company which is developing their own
software for their own purposes. It just so happens that we are using the
same kind of info and it would be beneficial to both companies to "trade"
info back and forth. The website is mostly updated by end users with a store
being able to see the info. My software is updated by stores only keeping
track of customer orders. Optimally I'd like to synchronize changes between
the two databases.

The other company is thinking that there needs to be a login process with
user name/password similar to a "post" in HTML. I've not found anywhere a
discussion on if this is possible within Access.

Thanks again.
James Deckert

"Mr B" wrote:

James,

I have recently developed a system for a client where their end user logs on
to a web site that I developed using asp.net to view (read only) data
specific to that user. The data is stored in an Access 2003 format database
file. This stroage file is actaully created by users in my client's office
using another Access 2003 Application that utilizes a split file design.

The users at the clients office make the needed modifications to the data
and then when they have completed their modifications, they click a button to
initiate code that creates a special .mdb file containing the needed data for
a specified end user. The user is then prompted if they would like to have
this special .mdb file uploaded to the server. The file is uploaded to the
server via FTP, replacing the existing file.

In our application we are not allowing the end users to make any
modifications to the data, thus we have no need to retrieve any existing data
before the upload process. If you plan to have your processes run in off
hours (when users are not activly using the web site) then you could actually
download a copy of the exiting database file using FTP, do what ever
processing you need to do to acquire any updated data. After downloading the
current data, you could then at some point upload any new data or records or
whatever.

You might actully want to at least consider moving the entire process to
asp.net. Using asp.net you can maintain any and all data in real time
without having to have the uploading and downloading with FTP going on.

These are just some of my thoughts on the subject, but I hope that some of
these thoughts help you in trying to find a solution to your project.

If you have questions or comments concerning the asp.net thing, you can
email me from my website shown here below my signature.

--
HTH

Mr B
askdoctoraccess dot com


"JamesDeckert" wrote:

Information about interaction between Access and the internet seems to be
sparse. I'm not wanting to put the back end on the net. What I'm wanting to
do is share information between my Access system and a website (probably as a
batch process once a day). I've some stores who use my system, and another
company is developing a web based system open to customers to update their
orders. I'd like to download those changes into Access, and vice versa (when
a store makes changes).

I've found an http possibility for receiving data, and some ftp code (which
I haven't tried yet) for downloading/uploading. But my question is, is there
a "best" process for this kind of thing. Also, the site may want security
verification (user name, password). Is there some way to "post", or talk back
and forth briefly "real-time" between the two systems?

I envision the files being shared to be small (a few K) XML/text/CSV type
files.

Of all my Access books, none discuss sharing info with the internet.

Thoughts? Ideas?

thanks,
James Deckert
.

Relevant Pages

  • RE: sharing info between Access and a website
    ... server via FTP, replacing the existing file. ... before the upload process. ... hours (when users are not activly using the web site) then you could actually ... I'd like to download those changes into Access, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Cant delete folders in ftproot
    ... This is a natural result of allowing anonymous users the right to upload ... _and_ download from the same area. ... manually, rather than through FTP. ... A 'tagging' incident doesn't generally mean that you've allowed a hacker to ...
    (microsoft.public.inetserver.iis.ftp)
  • Re: Good PCI Wireless LAN for HP PC?
    ... Note that the ftp is for a download, ... There's no upload, so there's nothing to worry about. ... comments to your firewall vendor. ...
    (alt.internet.wireless)
  • Re: Hello
    ... permissions to be downloaded again (by anon user). ... The idea here is to stop your FTP server being used as a warez site. ... WebDAV over HTTPS or a form based upload ... automatically make any uploaded files available for download. ...
    (freebsd-questions)
  • Re: POTS line quality help
    ... registers where the smallest mistake will cause trouble read up on the +MS: command in the manual and pray that your modem implements it. ... In the UK you can choose your ADSL supplier and packages vary in both content, amount of download per month, speed and price. ... Modem: US Robotics 5686. ... 12.9K download, 13.0K upload and modem query I6 afterwards showed speed 14,400 and V42BIS and icon indicated 115,200bps. ...
    (sci.electronics.design)