Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 1st, 2007, 12:37 PM
Authorized User
 
Join Date: Feb 2007
Location: Wellingborough, Northamptonshire, United Kingdom.
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default Multi Site use of access

I have a MS access Calibration database this is to be used in several countries.
We have a server but traffic needs to be kept at a minimum. (poor server)
The data on each user site is specific to each country, But (there’s always a but) Corporate would like to view each country and run stats on the combined data.
As more branches open they will need to taking on this database, extendibility is essential
My thinking is to have an individual data table sets held locally and periodically sent append data to a table on the server for corporate to view with there own bespoke front end.
Is this possible and how?
Or am I barking up the proverbial tree
 
Old February 2nd, 2007, 08:42 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

You can do this as long as there are not conflicts in the data when it gets downstream (like PK field issues)

I would automate an update from the user's computer during downtime if that is possible. You can do this from the application, or from a script.

Also, what is the number of transactions that prevent you from making these updates one row at a time from the user's end when an insert or update is committed?

What kind of network are you on as well? Do the user's have to log in to the central network? Or is the connection persistent?



mmcdonal
 
Old February 2nd, 2007, 09:13 AM
Authorized User
 
Join Date: Feb 2007
Location: Wellingborough, Northamptonshire, United Kingdom.
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The data is independent each country has its own records

Automating an update is the bit I don’t know
I have only done stand-alone applications before
plus this needs to be done by user

The server and other users are logged off at work end and being in different counties their times are different. Also IT are jittery at running applications over the network.

We have a secure network with logins for each user


 
Old February 2nd, 2007, 09:26 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

This is problematic. You might have the users click a button to pass new data. You might automate it on open, since users are more likely to wait while the database is opening than when it is closing or some other time.

I would create a local log table (hidden) to log the data that was passed out, and check the table to see what new files need to be passed.

You can do this by either creating a DateCreated and DateModified field in all of the tables that will pass data, and then check the date and time of the last update, and then send records where either the date created or date modified is later, Or create a Yes/No field, and then check for yes if the data is new or updated, and then UNCHECK the field when the record is sent.

I would be inclined to do all this on the On Open event of the main form that opens when the users open the application. BUT it depends on how much data is going to be moved around.

Also, with error checking, you will want to have some method to confirm that the data that was sent was committed on the main database. And perhaps a check to make sure no errors were thrown during transmission, etc. Then perhaps some back checking from the main database...

How much data are we talking about on a daily basis from the busiest site?

Do you need more help on this?




mmcdonal
 
Old February 5th, 2007, 08:43 AM
Authorized User
 
Join Date: Feb 2007
Location: Wellingborough, Northamptonshire, United Kingdom.
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for youre help
on last question, To send this data should I use an update query?





Similar Threads
Thread Thread Starter Forum Replies Last Post
Multi-site XML foddie XML 0 June 13th, 2007 05:31 AM
C# and SQL express 2005, multi-user access ?? Boudy C# 2005 4 February 27th, 2007 04:43 AM
Multi language web site asifqua Classic ASP Databases 9 December 5th, 2006 04:34 AM
Save data in access using multi user sandeepbhawsar ADO.NET 2 December 4th, 2006 08:48 AM
String access by character bug in multi-dimensiona richard.york Pro PHP 1 September 6th, 2003 05:57 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.