Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - on-line / off-line database tables
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

on-line / off-line database tables

 Post Reply Post Reply
Author
snapey View Drop Down
Newbie
Newbie


Joined: 28 July 2002
Location: United Kingdom
Status: Offline
Points: 33
Post Options Post Options   Thanks (0) Thanks(0)   Quote snapey Quote  Post ReplyReply Direct Link To This Post Topic: on-line / off-line database tables
    Posted: 08 January 2005 at 6:34pm
Does anyone have any experience of importing an on-line database into an off-line one?

I need to develop an event booking database. The off-line version will be taking all client bookings as well as the general administration of the event such as who has paid etc. The off-line database will be used when people send in paper booking forms or via the telephone.

I was going to build an on-line form that writes into tables on an Access 2000 DB using ASP. The administrator will then need to download the database every few days and merge it in with the main database. Can this be done?

Also, any tips for handling the situation where someone revisits the site and needs to amend their booking.
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 08 January 2005 at 6:52pm
I think you're headed for trouble there. You'd need to write a custom script to sync the two access db's and they'd still be highly likely to get out of sync anyway.
 
Why not just write an admin interface to the online db so the folk in the office can update it on behalf of the call-ins and paper bookings?
 
Put the admin interface in a separate directory so you can password protect it. If you put it in a separate sub-domain, you could also wrap it with ssl.
 
If you need to use built in access reporting capabilities, have them download the online db for fresh reporting. Use the online db as the single-source master.

Lead me not into temptation... I know the short cut, follow me.
Back to Top
zaboss View Drop Down
Senior Member
Senior Member


Joined: 20 August 2002
Location: Romania
Status: Offline
Points: 454
Post Options Post Options   Thanks (0) Thanks(0)   Quote zaboss Quote  Post ReplyReply Direct Link To This Post Posted: 08 January 2005 at 7:05pm
I was having the same problem, even worst as it wasn't only one operator, but about 40, spreaded in about 20 different cities. Should they all have internet access smoothly, it  wouldn't be a problem, but they have only limited access. So, what I did was to use the online db as the main database (as suggested by dypers), and the each operator database as individual database. I have  created a form in access that creates a text file after each raport is filled. When they got connected, just upload those text files and with a script I read them and insert them in the main db. With a proper deadline setting, I know at any time the exact situation of the main db.
Cristian Banu
Soft 4 web
Back to Top
snapey View Drop Down
Newbie
Newbie


Joined: 28 July 2002
Location: United Kingdom
Status: Offline
Points: 33
Post Options Post Options   Thanks (0) Thanks(0)   Quote snapey Quote  Post ReplyReply Direct Link To This Post Posted: 08 January 2005 at 7:33pm
Thanks guys,
This was the way I was thinking except that it means that I have more screens to create and the security of the database becomes more critical.
 
The compromise I have been thinking about is that
a) I provide a CSV on demand which they download and merge into the database. The on-line table is then emptied.
 
b) they then upload an extract of the database
 
c) when someone wants to query their booking I first look in the 'new entries' and if its not there, look in the confirmed bookings. Any changes get posted as completely new entries back to the 'new bookings table with a flag to say its an update.
 
Still happy to hear any further ideas.
Mark
 
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.