By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 2,185 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

Replication of access db

P: n/a
Hi

We have an access database running on a win2k server over the internal LAN.
The server is protected by MS ISA Server from outside world. Is there a way
to periodically replicate the access database to another server that
residues outside of the ISA Server? The reason is that we want to run our
website on the second server but don't want it to access out main server
directly. Rather we want our main server to provide the database updates to
the web site server from time to time.

Thanks

Regards
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
An app I wrote for courier services enables clients to login to a web page
and view the current status of their deliveries.

This is done with an Access MDE sitting in a loop and every 3 minutes
writing the current state of affairs to an MDB. The new MDB set to the
server every 3 minutes includes delivery info for the day and current
usernames and passwords = a layer of protection meaning if someone is trying
to crack the web site's login, they need to do it in at most 3 minutes, and
then be successful again with the new encryption within the next 3 minutes
and so on.

It then FTPs the MDB to the web server. The web page is asp "classic".

The user either logs in or refreshes the page to view current run info (
current in time frames of 3 minutes )

yes, better done with .net remoting and asp.net, but clients are reluctant
to install new software ( the .net framework ) because they view their
computers as something they do not understand, it works now, if they install
the .net framework = that is a change that could break their computer = no
change on their side is good.

I think you can understand the pseudocode and fill in the blanks from here.

John Bickmore
www.BicycleCam.com
www.Feed-Zone.com

"Chuck Grimsby" <c.*******@worldnet.att.net.invalid> wrote in message
news:f5********************************@4ax.com...

FTP the database through the firewall.

On Mon, 5 Jan 2004 00:11:30 -0000, "John" <Jo**@nospam.infovis.co.uk>
wrote:
We have an access database running on a win2k server over the internal LAN.The server is protected by MS ISA Server from outside world. Is there a wayto periodically replicate the access database to another server that
residues outside of the ISA Server? The reason is that we want to run our
website on the second server but don't want it to access out main server
directly. Rather we want our main server to provide the database updates tothe web site server from time to time.

--
Only Adults Have Difficulty With Childproof Caps.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.